OraFAQ Forum: Server Administration » Unicode version problem?

Home » RDBMS Server » Server Administration » Unicode version problem?

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

Unicode version problem? [message #111635]

Fri, 18 March 2005 06:01

wilsonchg
Messages: 4
Registered: March 2005

Junior Member

How to know the version of unicode running in my Oracle 9i Database?

Thanks.

Report message to a moderator

Re: Unicode version problem? [message #111638 is a reply to message #111635]

Fri, 18 March 2005 06:26

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

SQL> SELECT *
  2    FROM nls_database_parameters
  3   WHERE parameter LIKE '%CHARACTERSET%';

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               WE8ISO8859P1
NLS_NCHAR_CHARACTERSET         AL16UTF16

According to the Oracle Globalization Support Guide, AL16UTF16 (above) is Unicode version 3.2 (Oracle 10g). You can do the same to lookup your Unicode version.

Best regards.

Frank

Report message to a moderator

Re: Unicode version problem? [message #111641 is a reply to message #111638]

Fri, 18 March 2005 06:35

wilsonchg
Messages: 4
Registered: March 2005

Junior Member

Only know it is UTF8
but i wanna to know the version of the unicode running in my DB.
(e.g. 3.1, 4.0 ...etc.)

PARAMETER VALUE
------------------------------ ----------------------------------
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8

Report message to a moderator