Oracle NLS_LANG and ODBC setting

[KY.Chuang]

Dear all,
I have a question about Windows ODBC.
Oracle Database 8.X installed in HP Unix 11.0,
When I created Databse Object which assign
Chatacter Set and National Chatacter Set was "ZHT32EUC".
The Question is :
I want to use Microsoft ACCESS througth "Microsoft ODBC for Oracle" to query Database.
But Chinese text of query data is not correct.
I think the question point should be NLS_LANG.
How to set NLS_LANG in "Microsoft ODBC for Oracle"?
I tried to change Oracle NLS_LANG (ZHT32EUC) in Windows Registry.
It have useful to Oracle Sqlplus,
but No useful to Microsoft ACCESS.

Thanks.

[Massimo Bianchi]

Hi,
check metalink note Note:231953.1

If you have no access, i will paste an extract for you.


Massimo

[KY.Chuang]

To Massimo ,

You are right, I have no permission to access this website
<>


Thanks.

[Massimo Bianchi]

Some notes for you :)

[Massimo Bianchi]

It's not always good the first.... :(

[Yogeeraj_1]

hi,

Do you have a UTF-8 Database?

try:
on client registry, set NLS_LANG=TRADITIONAL CHINESE_CHINA.UTF8(or NLS_LANG=SIMPLIFIED CHINESE_CHINA.UTF8)

On a Windows 2000: --> Control Panel --> Regional Options --> Your Locale (in the general tab) must be set to Chinese. Also the " Set Default" must be set to Chinese.

hth
Yogeeraj