Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem reading VARCHAR fields from Oracle 9i

12381Mar 4 2002

I'm having a problem when I'm trying to read data from VARCHAR field from the oracle objects. Class was generated by JPublisher and it worked fine with 8i, with 9i it returns byte representation of the string and not the string itself. I'm using latest 9i jdbc drivers.

something like this: "0x46696E746170204D6F64656C20536574"

After looking through the forums, the only solution that I found was to include nls_charset12.zip into classpath - it didn't help.

I found out (select userenv('LANGUAGE') from dual) that Oracle 9i server has following charset - AMERICAN_AMERICA.WE8MSWIN1252. And Oracle 8i, the one used to generate classes, had - WE8ISO8859P1. Is this the problem? If yes, is there are a way to setup conversion parameter for Oracle connection, instead of converting every string in result? If not, can you, please, tell me what else can be done?

Thanks,
Andrei Snitko

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2002

Added on Mar 4 2002

#database-key-features, #globalization-support

4 comments

382 views