Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

ORAOLEDB US7ASCII character set database drive connections, Chinese garbled, how to solve?

user6709711May 5 2015 — edited May 5 2015

Hi All,

The server character set:SIMPLIFIED CHINESE_CHINA.US7ASCII

The client's character set:SIMPLIFIED CHINESE_CHINA.US7ASCII

Using OraOLEDB. Oracle as a driver: "Provider=OraOLEDB.Oracle.1;User ID=tui;Password=ok;Data Source=orcl"

SQL Code: select '中文' from dual;

Return: ??

But in the SQL/PLUS is possible.

If set the registry value "ORA_NLS_CHARACTERSET_CONVERSION"="NO_CHARACTER_SET_CONVERSION",Then Return UTF8 character,But not what I need.

Can't change the database character set, how can I use Chinese characters?

ORA_NLS_CHARACTERSET_CONVERSION: are there any other options?

thank you!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2015
Added on May 5 2015
#oracle-provider-for-ole-db, #windows-and-net
0 comments
1,199 views