Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multi bytes character

2670775Oct 18 2016 — edited Oct 25 2016

I have a database in character set UTF8 . version 11g2.

And have a table 1 col nvarchar2(20).

Then I use sql loader to load some chinese words.

pastedImage_0.png

After loading. I select in sqlplus through putty, here is the results.

pastedImage_1.png

I am wondering the character with 4 bytes unable to store or display correctly in oracle database ?

And Oracle character set UTF8 will store character from 1 to 3 bytes only ? and so that 4 bytes can't identify ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2016
Added on Oct 18 2016
#database-key-features, #globalization-support
18 comments
4,318 views