Skip to Main Content

Database Software

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!

Use Chinese characters in where clause of Query

169420Sep 24 2007 — edited Oct 9 2007
I have the following questions in working with the Simplified Chinese characters in Oracle:
The Simplified Chinese characters can be loaded to the NVARCHAR2 column of a table using SQLLDR with characterset ZHS16GBK defined in the control file and can be displayed in SQLPlus. They can also be inserted through linked table of Microsoft Access. But why the Simplified Chinese characters cannot be inserted directly through SQLPlus?
Why the query cannot be executed properly (i.e. no record is selected) in SQLPlus or through linked table of Microsoft Access, if the selection criteria or the WHERE clause contains the Simplified Chinese characters?
Do I need to create a unicode database (i.e. database characterset = AL32UTF8 and national characterset = AL16UTF16) in order to solve the above problems?


For you information, the current configuration / settings of my working environment is shown below:
Server side
Operating System: AIX 5.3
Oracle Database version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
Oracle Database characterset: US7ASCII
Oracle National characterset: AL16UTF16

Client side
Operating System: English Microsoft Windows XP Professional Version 2002 (SP2)
Oracle Client version: Oracle 10g
Locale: Chinese (PRC)
NLS_LANG in registry: AMERICAN_AMERICA.ZHS16GBK
Microsoft Access version: Microsoft Office Access 2003 (11.6566.8122) SP2

Many thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2007
Added on Sep 24 2007
6 comments
4,983 views