Record search on double-byte value failed using tomcat and oracle

I managed to put double-byte value (chinese) in a database record and retrieving correctly using jsp.

However, when I tried to search for the record with double-byte value in WHERE clause (constructed at runtime), it always failed to match the record, eventhough the final displayed SQL is correct ?

Thanks in Advance.

[344 byte] By [vljdc] at [2007-9-26 1:16:22]

«« Invalid cursor state
»» Swing Applets,Problems when importing libraries like com.borland....

# 1

More Info:Database: Oracle 8.1 on NTTomcat 3.2.1 on Red Hat Linux 6.2Regards.

vljdc at 2007-6-29 0:44:08 >

top of Java-index,Enterprise & Remote Computing,Web Tier APIs...

# 2

I have to suspect that this is a problem with Oracle. I'

m more familiar with DB2 but will give this a shot...Have you tried to CAST the search condition into the proper double-byte datatype? Perhaps you could also CAST the field to search through as a double-byte field. You should check the Oracle reference for any and all info about double-byte character fields.

rloffelm at 2007-6-29 0:44:08 >

Enterprise & Remote Computing

Web Tier APIs

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Record search on double-byte value failed using tomcat and oracle

Enterprise & Remote Computing New Topic

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified