-
How to change Character set for oracle 8i databases
Hi All
What is way to change CHARACTER SET for the database ?
I have created Database in Oracle 8.1.6 with CHARACTER SET WE8ISO8859P1. Since this is 8-bit character set it will not support unicode charachetrs. I need the columns to accept NVACHAR / NCHAR values.
So as to change CHARACTER SET, i already workout following process.
1. SHUTDOWN IMMEDIATE; " BACKED UP DATABASE "
2. STARTUP MOUNT;
3. ALTER SYSTEM ENABLE RESTRICTED SESSION;
4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;
5. ALTER DATABASE OPEN;
6. ALTER DATABASE CHARACTER SET AL16UTF16;
SETP 6 HAS GIVEN FOLLOWING ERROR
ALTER DATABASE CHARACTER SET AL16UTF16
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
Can any one help me out ? Do i need to recreate database again? what should be ideal character set for my scenario ?
-
you need to recreate the database, but see Metalink note 66320.1
Last edited by davey23uk; 09-08-2005 at 04:25 AM.
-
Try this, WE8MSWIN1252 is a superset of WE8ISO8859P1
-
Try this, WE8MSWIN1252 is a superset of WE8ISO8859P1
Still same error..
-
-
Hi
I have drop database and recreated again with UTF8 character set but it is still not working for me. Can you tell me which is supported character set that will accept unicode characters.
see the example below. I have logged in with sys as sysdba
SQL> CREATE TABLE EMP (ENO NUMBER (10), NAME NVARCHAR2 (50) )
2 TABLESPACE MASTERS_DATA;
Table created.
SQL> ALTER TABLE EMP MODIFY("NAME" DEFAULT 0);
ALTER TABLE EMP MODIFY("NAME" DEFAULT 0)
*
ERROR at line 1:
ORA-02262: ORA-%05d occurs while type-checking column default value expression
SQL> DROP TABLE EMP;
Table dropped.
SQL> CREATE TABLE EMP (ENO NUMBER (10), NAME VARCHAR2 (50) )
2 TABLESPACE MASTERS_DATA;
Table created.
SQL> ALTER TABLE EMP MODIFY("NAME" DEFAULT 0);
Table altered.
-
wat is the version of ur database???
-
8.1.6 Enterprise Edition..
-
Did u set the registry NLS_LANG to AMERICAN_AMERICA
OR U can use AL24UTFFSS for National Character Set
Last edited by tabreaz; 09-08-2005 at 11:41 AM.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|