ODBC and Kanji

[imfein]

I have a general question and a specific question.

If I have Kanji data in a DB2 database, how do I extract
that data out with my ODBC application?

Does my application have to do any data conversion, or
does the ODBC driver do the conversion for me (in other
words, can I tell the driver to provide me with the
data in SQL_C_CHAR format, or do I have to specify some
sort of "wide-character" format)?

 

[chintan]

If you have a W2K system the most appropriate thing to do will be to change your locale to Japanese which is code page 932 and restart the system when it asks for it. The system should ask for a restart or else you have not done the setting change properly. You can change the locale by using the regional settings in the control panel. Also if DB2 ODBC client has an option to specify the session character set then you need to specify that too. Hope it helps.

-Chintan.