Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Character set conversion

    Hi,

    Assuming client system's character set was ZHS16GBK ( 2 bytes for each character ), and both server's and Oracle database system's character set was UTF-8 ( 3 bytes for each character ).

    If we run SQLPLUS from client system ( with Oracle client installed ) and insert a Chinese character ( 2 bytes per character) into a table, will the Chinese character be automatically converted to UTF-8 ( 3 bytes per character ) when it was stored in Oracle database table.

    Do we need to set anything in order for the conversion to take place automatically?

    Thanks & best regards,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >will the Chinese character be automatically converted to UTF-8 ( 3 bytes per character ) when it was stored in Oracle database table.

    I am curious as to why you thought it would be better to ask this question here as opposed to looking in the database to see the ACTUAL results?
    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
    Mar 2004
    Posts
    3
    As I did not get the expected result, so I'm curious as what setting that will make it works. My client and server is on AIX.

    Thanks & best regards,

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >As I did not get the expected result
    Depending upon EXACTLY what you did from where, what you saw may not be what you have.

    In other words, the client you used to look at the contents can impact what you saw.
    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
    Mar 2004
    Posts
    3
    Hi,

    Thanks for the reply.
    But I just want to have a confirmation that Oracle will do a character set conversion in the above situation. Since I don't get a clear clue from Oracle manual for that question.

    Thanks & best regards,

Posting Permissions

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