[jkh]

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,

[anacedent]

>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?

[jkh]

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,

[anacedent]

>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.

[jkh]

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,