By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,691 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,691 IT Pros & Developers. It's quick & easy.

Cannot Store Chinese Characters In Oracle 9.2 Database

P: 1
Hi,

I'm having trouble localizing my Oracle 9.2 / ASP web application for our Chinese-speaking users.

My Oracle 9.2 Database has NLS_NCHAR_CHARACTERSET set to AL16UTF16.

I've set up a test table thus:

Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE "TBL_TEST_CH"
  2. (
  3. field1                     NVARCHAR2(40),
  4. field2                     NVARCHAR2(40)
  5. )
  6. /
  7.  
I have the chinese character set installed on my database / web server (same box), as well as a test client machine. I can see chinese characters in my web browser, and can enter them in a test ASP page I've set up. When I execute an insert statement via ADO, the insert statement seems to work, but the result is that the data seems to be stored as upside-down question marks.

I thought perhaps the data was being somehow scrambled between the web app and the database, so I set up an external table import the chinese data from a unicode text file:
Expand|Select|Wrap|Line Numbers
  1. CREATE TABLE kenny.ch_import
  2.     (
  3.     FIELD1        NVARCHAR2(255),
  4.     FIELD2        NVARCHAR2(255)
  5.     )
  6.     ORGANIZATION EXTERNAL (TYPE oracle_loader
  7.     DEFAULT DIRECTORY ext_dat_dir
  8.     ACCESS PARAMETERS
  9.     (RECORDS DELIMITED BY ":"
  10.     FIELDS TERMINATED BY "~"
  11.     missing field values are null)
  12.     LOCATION (ext_dat_dir:'test_ch.txt'))
  13.     reject limit unlimited
  14. /
  15.  
However, when I query the data in the external table using my web application, it comes back with garbage like "1" and the like.

I'd really appreciate any suggestions on what I could do next to determine exactly where the problem lies. I've not been able to convince myself that the database is correctly storing the chinese character data, but I appreciate equally that the problem could lie elsewhere.

Thanks in advance,

Kenny McEwan.
Jan 23 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.