hi ppl out there

mi using java, do anyone know how to handle special character for sql?
doing a project and need help.. thanks alot..

I guess I don't understand what you mean by "special character" (to me that means certain ASCII values that cause things to happen, like EOL, etc). Can you explain a bit more for me???

-PatP

hi

for example, i type select * from user where user='o'connor';
o'connor is actually one of the data in the database.
when that query is submited, it return a error:
Error: Syntax error (missing operator) in query expression 'user ='o'conner';'. (State:37000, Native Code: FFFFF3E4)

thanks

For single quotes in a string use 2 single quotes together:

EX:

'o''connor'

Note: This is 2 SINGLE quotes, and not 1 double quote.

So then you mean characters that SQL uses for special purposes, such as the apostrophe? Different dialects of SQL treat different chacters as "special", so you'll really have to read the documentation for the SQL engine that you are using, and follow it's guidlines for how to handle them.

-PatP