Oracle database character set. [message #674923] |
Fri, 22 February 2019 07:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/dbecdf14a44b8698c09d13920a9eb3b2?s=64&d=mm&r=g) |
kalenko
Messages: 40 Registered: January 2018
|
Member |
|
|
Hi,
I have some questions about Oracle 11gR2:
1. What is Database character set? and what is National character set? Is Database character set for the varchar2 column? and Is National character set for the nvarchar2 column?
2. What is the difference between AL32UTF8 and UTF8? and what is the difference between AL16UTF16 and UTF16?
Please give me the answers.
Thanks.
|
|
|
Re: Oracle database character set. [message #674924 is a reply to message #674923] |
Fri, 22 February 2019 08:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68653 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1. Yes
2. UTF8 = Unicode UTF-8 version <= 3.0 with some extensions (CESU-8, HKCSC), obsolete
AL32UTF8 = standard Unicode UTF-8 version >= 3.1
AL16UTF16 = UTF-16 with big-endian byte order
UTF16 = Unicode UTF-16 with same endianess than your system one
[Updated on: Fri, 22 February 2019 08:30] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|