Home » RDBMS Server » Server Administration » Changing NLS_CHARACTERSET on Xepress Edition
icon5.gif  Changing NLS_CHARACTERSET on Xepress Edition [message #196637] Fri, 06 October 2006 05:42 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

I tried to install oracle XE on windows2003 and got any problem as the following:
1. Is the oracle XE created database used NLS_CHARACTERSET = AL32UTF8 by default?

2.I tried to change it to TH8TISASCII by :

sql>alter database fujudb character set TH8TISASCII;
ORA-12712: new charactor set must be a superset of old character set

3. Is there any way to solve it?

Thanks for advance !

Chara

Report message to a moderator

Re: Changing NLS_CHARACTERSET on Xepress Edition [message #196755 is a reply to message #196637] Sat, 07 October 2006 01:08 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
ORA-12712: new character set must be a superset of old character set
Cause: When you ALTER DATABASE ... CHARACTER SET, the new character set must be a superset of the old character set. For example, WE8ISO8859P1 is not a superset of the WE8DEC.
Action: Specify a superset character set.

Report message to a moderator

Previous Topic: Multiple Oracle Instances on one server
Next Topic: Oracle XE - Can't "Go to Database Home" ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:28:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.