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...

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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


Report message to a moderator

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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

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!

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 01:35:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.