469,609 Members | 1,437 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Cannot Store Chinese Characters In Oracle 9.2 Database

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
0 3866

Post your reply

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

Similar topics

1 post views Thread by Jeff | last post: by
1 post views Thread by David A. Caballero J. | last post: by
reply views Thread by Larry Neylon | last post: by
8 posts views Thread by pabv | last post: by
1 post views Thread by Jason Chan | last post: by
5 posts views Thread by DaveRook | last post: by
reply views Thread by Solution2021 | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.