Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2009
    Posts
    4

    Unanswered: Retrieve chinese caracters from table

    Thanks, everyone.

    I have a table named TEST with only one column.

    When a run this statement work correctly
    INSERT INTO TEST VALUES ('距离哦阿');

    but when I try to retrieve the data get another diferent information.
    SELECT * FROM TEST
    锟斤拷锟斤拷

    I have set the
    NLS_CHARACTERSET to AL32UTF8
    NLS_NCHARACTERSET to UTF8

    when I create the DataBase.

    Plase help me with this?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Problem could be data presentation issue with client OS

    what is column name in TEST table?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2009
    Posts
    4

    Retrieve chinese caracters from table

    Hi anacedent.

    The name of the column is NAME_CHINESE, the type is VARCHAR2.

    Thanks for your help.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SELECT ASCIISTR(NAME_CHINESE) FROM TEST;

    post results from above.
    This will show if the chinese characters are really in the DB or not.
    If the Chinese characters are in the DB, then the problem is a data presentation issue with the client s/w & client OS.
    If the Chinese characters never got into the DB, then Oracle can not be expected to return them (Garbage In, garbage out).
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Nov 2009
    Posts
    4

    Retrieve chinese caracters from table

    Hi anacedent,

    The result from the query was:

    ASCIISTR(NAME_CHINESE)
    \FFFD\0333
    \FFFD\FFFD\FFFD\FFFD\FFFD\01BB\FFFD
    \02B9\FFFD\FFFD\FFFD\FFFD\FFFD
    \0169\FFFD\FFFD\02AE\FFFD\FFFD\FFFD\FFFD\FFFD\FFFD \FFFD

    What does the result means?

    Thanks.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ASCIISTR

    ASCIISTR takes as its argument a string, or an expression that resolves to a string, in any character set and returns an ASCII version of the string in the database character set. Non-ASCII characters are converted to the form \xxxx, where xxxx represents a UTF-16 code unit.

    To my untrained eye the contents of the DB might not contain what you think it contains

    What are the ASCII representations for the Chinese characters you expect in DB?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Nov 2009
    Posts
    4
    What are the ASCII representations for the Chinese characters you expect in DB?
    That's dificult question I don't know.

    For example I get for a traductor this simbols 接受 that represent a text in chinese.

    I insert that text into a table.
    INSERT INTO TABLE VALUES ('接受')

    when I retrieve the values I get garbage like this.
    ʹ�����
    �����ƻ�

    Also I discovered that if I change my regional settings to chinese I can see the caracters correctly.

Posting Permissions

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