Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Issue with character set conversion using Oracle ODBC client

388387Aug 2 2012 — edited Aug 2 2012
Hello All,

We are trying to migrate a 10g database from WE8ISO8859P1 to AL32UTF8 character set.

We have proceeded as follow :
* After running csscan and csalter, we have exported the content of the WE8ISO8859P1 database instance.
* We created as new instance using AL32UTF8 character set.
* We imported the data in the new instance.

The database is accessed by two kind of clients : a java application server and a legacy C++ software using ODBC connection.

The java application server works fine with the AL32UTF8 instance, however the C++ software fails.

Here are the details :
* Database 10g 10.2.0.4
* C++ software running with :
- Windows XP SP3
- Oracle ODBC Driver 10.02.00.01
- NLS_LANG set to FRENCH_FRANCE.WE8MSWIN1252

The C++ software fails with the message with the AL32UTF8 database instance : "[Oracle][ODBC]Syntax error or access violation"
It still works very well with the WE8ISO8859P1 database instance.

It looks like the Oracle ODBC Driver is not performing character set conversion.

Is there a complementary parameter to NLS_LANG that should be set ?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 30 2012
Added on Aug 2 2012
#database-key-features, #globalization-support, #odbc
1 comment
698 views