Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Location
    Devon, England
    Posts
    1

    Unanswered: Chinese text in a non Unicode database

    I have a requirement to store Chinese characters into a column within a table in a non Unicode database. All other textual columns in the database are stored as English text. I have done some reading on the subject and it looks like this can be achieved by using the data type NCHAR or NVARCHAR2 and amending certain NLS and Oracle init parameters. I have a database with the NLS_NCHAR_CHARACTERSET set to AL16UTF16 and have set-up my session NLS parameters to be as follows:

    ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
    ALTER SESSION SET NLS_TERRITORY='CHINA';

    However when I attempt to copy and paste a Chinese character, (e.g. 第一批异体字整理表) into an SQL*Plus window the characters get replaced by the symbol ?. I can copy and paste the characters into Notepad and other windows applications so I think the issue is Oracle related. Can anyone advise what I need to do so I can insert Chinese characters into a single NVARCHAR2 database column?

    Regards

    Collin

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Nls_lang

    Try also setting the NLS_LANG environment variable.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •