Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle NLS_LANG and ODBC setting

KY.Chuang
Advisor

Oracle NLS_LANG and ODBC setting

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.
Service is King
5 REPLIES
Massimo Bianchi
Honored Contributor

Re: Oracle NLS_LANG and ODBC setting

Hi,
check metalink note Note:231953.1

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


Massimo
KY.Chuang
Advisor

Re: Oracle NLS_LANG and ODBC setting

To Massimo ,

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


Thanks.
Service is King
Massimo Bianchi
Honored Contributor

Re: Oracle NLS_LANG and ODBC setting

Some notes for you :)
Massimo Bianchi
Honored Contributor

Re: Oracle NLS_LANG and ODBC setting

It's not always good the first.... :(
Yogeeraj_1
Honored Contributor

Re: Oracle NLS_LANG and ODBC setting

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)