Home » SQL & PL/SQL » SQL & PL/SQL » quotes problem
quotes problem [message #19998] Tue, 23 April 2002 07:06 Go to next message
massa
Messages: 12
Registered: April 2002
Junior Member
I am programing in asp and I am working on a program that make some querys on an oracle database.
The asp code works but not the querys and one paritcularly :
select * from people where User_Name='John';

The problem comes from the ' and it display this error :
ORA-12704: character set mismatch

I have tried the "", {}, [[]] and () but none of them worked so if someone has an idea, it could help.
Thanks
Christophe
Re: quotes problem [message #19999 is a reply to message #19998] Tue, 23 April 2002 07:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
where user_name='John' is correct.
check the datatype of the column.
sql>desc people;
and
if the data is something like JOHN'S then u need to give as
where user_name='John''s'
Re: quotes problem [message #20012 is a reply to message #19998] Wed, 24 April 2002 06:17 Go to previous message
motiram
Messages: 21
Registered: January 2001
Junior Member
Probably you should check if your query is enclosed in another single quote. Can you put the complete part of code where you are getting problem. If query is executed in Sqlplus it should be executed in ASP, JSP or anything.

Cheers.
Previous Topic: sql query
Next Topic: urgent ...how to make this simple query run faster
Goto Forum:
  


Current Time: Thu Mar 28 14:10:34 CDT 2024