Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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)