Re: national character set and database set

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 13 Dec 2006 08:33:48 GMT
Message-ID: <1165998826.192831@proxy.dienste.wien.at>

aman.oracle.dba <aman.oracle.dba_at_gmail.com> wrote:
> Is it correct that oracle is using only UTF8 for database character set.

Here's the spoiler:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/applocaledata.htm#sthref1958

To make it not too easy for you, some additional clarifications:

You can use character sets that are not based on Unicode. Unicode itself is not a character set encoding. On Oracle, You can have UTF-8 and UTF-16, but the latter only as national character set called AL16UTF16.
Oracle calls UTF-8 either UTF8 or AL32UTF8, where the former is outdated and should not be used unless necessary for backward compatibility reasons.

Yours,
Laurenz Albe Received on Wed Dec 13 2006 - 02:33:48 CST