UTF8

Casper1
Дата: 27.09.2004 21:03:38
help me!

NLS_NCHAR_CHARACTERSET=UTF8 на AL16UTF16 можно изменить без пересоздания?
Viewer
Дата: 28.09.2004 07:26:15
а попробовать что мешает ?
ALTER DATABASE CHARACTER SET AL16UTF16

ORA-12712: new character set must be a superset of old character set
Вячеслав Любомудров
Дата: 28.09.2004 07:59:11
Это было
tst> select * from nls_database_parameters;

PARAMETER                      VALUE
------------------------------ --------------------------------------
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_LANGUAGE                   RUSSIAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               CL8ISO8859P5
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_RDBMS_VERSION              9.2.0.5.0

20 rows selected.
Это просто в другом окошке
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  285684972 bytes
Fixed Size                   455916 bytes
Variable Size             134217728 bytes
Database Buffers          134217728 bytes
Redo Buffers               16793600 bytes
Database mounted.
Database opened.
SQL> alter system enable restricted session;

System altered.

SQL> connect / as sysdba
Connected.
SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter system set aq_tm_processes=0;

System altered.

SQL> alter database  national character set utf8;

Database altered.

SQL> alter database  national character set al16utf16;

Database altered.

SQL> select * from nls_database_parameters;

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_LANGUAGE                   RUSSIAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               CL8ISO8859P5
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_RDBMS_VERSION              9.2.0.5.0

20 rows selected.

И вообще, насколько я понимаю, главное, чтоб не было данных в столбцах с NCHAR