Home » RDBMS Server » Server Administration » character set conversion (9.0.0.1,RH 7.2)
character set conversion [message #310688] Wed, 02 April 2008 01:41 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
If i have to store data in multiple languages,which character set would work?

Do i need to recreate the database to chnage the charcter set?
Re: character set conversion [message #310694 is a reply to message #310688] Wed, 02 April 2008 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Depends on which languages you have to support
2/ See #1

Regards
Michel
Re: character set conversion [message #310713 is a reply to message #310688] Wed, 02 April 2008 02:55 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I have to use hindi and english both on some tables.
I have to load data through sql loader.
When i query i shall see english and Hindi data in there corresponding columns.

I guess i have to use UTF-8 but do i need to recreate the database

I didn't get this
2/
Quote:
See #1
Re: character set conversion [message #310714 is a reply to message #310688] Wed, 02 April 2008 03:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

you had two questions. two answers are given.
Re: character set conversion [message #310718 is a reply to message #310713] Wed, 02 April 2008 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case, you have to use AL32UTF8 and recreate the database unless your current database character set is US7ASCII.

Regards
Michel

[Updated on: Wed, 02 April 2008 03:34]

Report message to a moderator

Re: character set conversion [message #310719 is a reply to message #310688] Wed, 02 April 2008 03:49 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
In this case, you have to use AL32UTF8 and recreate the database unless your current database character set is US7ASCII

So,AL32UTF8 supports multiple languages and is a strict super set of US7ASCII.

My database has US7ASCII character set.
So just
SQL>alter database character set AL32UTF8;

would solve the issue.

[Updated on: Wed, 02 April 2008 04:23] by Moderator

Report message to a moderator

Re: character set conversion [message #310733 is a reply to message #310719] Wed, 02 April 2008 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
Yes, if you correctly use the database. Check with csscan.

Regards
Michel
Re: character set conversion [message #310752 is a reply to message #310688] Wed, 02 April 2008 05:20 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
So these are the steps

1)alter database set character set AL32UTF8;
2)shutdown immediate
3)Start up

?

[Updated on: Wed, 02 April 2008 05:32]

Report message to a moderator

Re: character set conversion [message #310758 is a reply to message #310752] Wed, 02 April 2008 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Step 0, run csscan to check data.

Regards
Michel
Re: character set conversion [message #310760 is a reply to message #310688] Wed, 02 April 2008 05:48 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Surely yes
Previous Topic: SQLPLUS NOT FOUND
Next Topic: Migrating from oracle 9i to 10g
Goto Forum:
  


Current Time: Fri Dec 09 00:01:53 CST 2016

Total time taken to generate the page: 0.05331 seconds