OraFAQ Forum: Server Administration » Oracle database character set.

Home » RDBMS Server » Server Administration » Oracle database character set. (oracle11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle database character set. [message #674923]

Fri, 22 February 2019 07:21

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.

Report message to a moderator

Re: Oracle database character set. [message #674924 is a reply to message #674923]

Fri, 22 February 2019 08:08

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Re: Oracle database character set. [message #674925 is a reply to message #674924]

Fri, 22 February 2019 08:28

kalenko
Messages: 40
Registered: January 2018

Member

Michel Cadot wrote on Fri, 22 February 2019 08:08

1. yes, yes
2. new and old/obsolete

Please explain to me more details about the questions number 2. Do you mean AL32UTF8 is new name and UTF8 is old name and both character sets do not have difference? Why UTF16 is obsolete and why UTF8 is not?

Report message to a moderator

Re: Oracle database character set. [message #674926 is a reply to message #674925]

Fri, 22 February 2019 08:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I updated my previous post while you were posting.

[Updated on: Fri, 22 February 2019 08:33]

Report message to a moderator

Re: Oracle database character set. [message #674927 is a reply to message #674923]

Fri, 22 February 2019 08:37

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Also, that's not how it works around here. Check out the documentation then come back with any questions based on what you've read Smile

Report message to a moderator

Re: Oracle database character set. [message #674928 is a reply to message #674926]

Fri, 22 February 2019 08:44

kalenko
Messages: 40
Registered: January 2018

Member

Why Oracle 11gR2 does not have UTF16?

Report message to a moderator

Re: Oracle database character set. [message #674929 is a reply to message #674928]

Fri, 22 February 2019 08:49

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because it has been introduced later.

Report message to a moderator

Re: Oracle database character set. [message #674930 is a reply to message #674929]

Fri, 22 February 2019 08:52

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Note that you cannot use UTF-16 for database character set and you cannot use UTF-8 for national database character set.
UTF8 is maintained only for backward compatibility.
(Take care of the hyphen in the names.)

Report message to a moderator