Home » RDBMS Server » Server Administration » Oracle database character set. (oracle11gR2)
Oracle database character set. [message #674923] Fri, 22 February 2019 07:21 Go to next message
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 messageGo to next message
Michel Cadot
Messages: 68624
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

Re: Oracle database character set. [message #674925 is a reply to message #674924] Fri, 22 February 2019 08:28 Go to previous messageGo to next message
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?
Re: Oracle database character set. [message #674926 is a reply to message #674925] Fri, 22 February 2019 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
gazzag
Messages: 1118
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
Re: Oracle database character set. [message #674928 is a reply to message #674926] Fri, 22 February 2019 08:44 Go to previous messageGo to next message
kalenko
Messages: 40
Registered: January 2018
Member
Why Oracle 11gR2 does not have UTF16?
Re: Oracle database character set. [message #674929 is a reply to message #674928] Fri, 22 February 2019 08:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because it has been introduced later.

Re: Oracle database character set. [message #674930 is a reply to message #674929] Fri, 22 February 2019 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.)

Re: Oracle database character set. [message #674966 is a reply to message #674928] Tue, 26 February 2019 07:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Any feedback?

Re: Oracle database character set. [message #675021 is a reply to message #674966] Tue, 05 March 2019 01:41 Go to previous message
kalenko
Messages: 40
Registered: January 2018
Member
Michel Cadot wrote on Tue, 26 February 2019 07:40

Any feedback?

Thanks, Michel, for your responses to my questions.
Previous Topic: XE 18c for Windows
Next Topic: How To Get the username that is currently Proxy To
Goto Forum:
  


Current Time: Thu Mar 28 09:18:13 CDT 2024