Skip to Main Content

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!

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
1 comment
742 views