ORACLE & JSP
------------
  I have got a Data capturing Screen in JSP which contains comments field. Sometimes the user enters special characters like '(Single Quotes) and &(Ampersand) in the comments field(eg. Here are some Program's to look, Bread& Butter).

When i insert the values into oracle thru JSP, it is inserting only upto the Single Quotes leaving the values after that.

Can anyone tell what should i do to insert the full value if the values contains characters like '(Single Quotes) or &(Ampersand).


Thanks in Advance


-Raj Jayaraman

I believe that you may have to escape single quotes. Unless you are using a PreparedStatement, you may have to explicity check for single quotes to escape them. In SQL, you usually encapsulate text strings (and dates) in single quotes. For example:

INSERT INTO my_table (
    id,
    name,
    comment
)

VALUES (
    123,
    'Joseph Yi',
    'This isn''t fun'
)

Sorry for my structuring, I do that so I can read it =p. Anyway, I don't know about 'standard' SQL, but having used Oracle, Sybase, and even MS Access as databases, I believe you merely have to escape your single quotes. The Statement object in Java has a void method called setEscapeProcessing(boolean enable) which is by default, true, so it was supposed to handle escaping special characters for you. However, this was not the case, and I had to manually check my strings for quotes and escape them =(. Anyway, if you need a method that performs escaping single quotes, I can provide one at your request.

Hello Joseph,

Can u help me by sending the method for escaping the single quote or converting the single quote into a double quote.

thanks in advance.


Prasath .
prasathb at yahoo dot com or bp8475@sbc.com