Home » RDBMS Server » Server Administration » Character Set
Character Set [message #284075] Wed, 28 November 2007 15:12 Go to next message
Daxesh
Messages: 61
Registered: July 2004
Member
Hello,
I have a database with the Character Set WE8MSWIN1252. Now for another small application I need the Character set AL32UTF8 for this application I do not need to create a separate database since its really small. So I was thinking that I can create a separate schema in the existing database. So it is doable? BTW what is the difference between WE8MSWIN1252 and AL32UTF8 character set?

Any input would be appreciated.
Thanks...
Re: Character Set [message #284083 is a reply to message #284075] Wed, 28 November 2007 16:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>So I was thinking that I can create a separate schema in the existing database.
NO. Charcter set settings are done at the database level NOT at the schema level.
It would be best if you simply created a new instance with the AL32UTF8 character set.
Re: Character Set [message #284104 is a reply to message #284075] Wed, 28 November 2007 22:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

difference between WE8MSWIN1252 and AL32UTF8 character set


Standard ASCII characters require 1 byte of storage space under in WE8(...) and in AL32UTF8, however, other characters require only 1 byte of storage space in WE8(...), but they require 2 or
more bytes of space in AL32UTF8.
Re: Character Set [message #284137 is a reply to message #284075] Thu, 29 November 2007 00:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

difference between WE8MSWIN1252 and AL32UTF8 character set?

All characters with code point < 128 in WE8MSWIN1252 have the same code point in AL32UTF8
All characters with code point >= 128 in WE8MSWIN1252 require 2 or 3 bytes in AL32UTF8.

Regards
Michel
Re: Character Set [message #284169 is a reply to message #284075] Thu, 29 November 2007 01:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Can also be 4 bytes long.
Re: Character Set [message #284176 is a reply to message #284169] Thu, 29 November 2007 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not when origin is WE8MSWIN1252.
But you're right AL32UTF8 can be up to 4 bytes (and even 8 for extended Unicode).

Regards
Michel
Re: Character Set [message #285261 is a reply to message #284075] Tue, 04 December 2007 02:37 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
@Michel:

Can I do these step following to change Database character set?

SQL> shutdown immediate
SQL> startup mount
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter system set aq_tm_processes=0;
SQL> alter database open;
.....
SQL> alter database character set internal_use AL32UTF8;
SQL> shutdown immediate
SQL> startup


Re: Character Set [message #285262 is a reply to message #284075] Tue, 04 December 2007 02:46 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

No. First run csscan and then take decision.
Re: Character Set [message #285266 is a reply to message #285261] Tue, 04 December 2007 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NO

1/ This is not a supported way to do it internal_use says what it is: INTERNAL USE

2/ If you do this you lose your database

There is one and only one way: create a new database and export/import the data.

Regards
Michel
Re: Character Set [message #285272 is a reply to message #284075] Tue, 04 December 2007 03:12 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Don't use data pump export/import, use old export/import.
Re: Character Set [message #285490 is a reply to message #284075] Tue, 04 December 2007 21:53 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel and Arju!

Your answer is very useful for my decision. The owner topic 's question is also same to me.

Thanks again!
Previous Topic: Abnormal Shutdowns
Next Topic: Why dont bind variable use MV.
Goto Forum:
  


Current Time: Mon Nov 04 05:21:54 CST 2024