OraFAQ Forum: Server Administration » character set conversion

Home » RDBMS Server » Server Administration » character set conversion (9.0.0.1,RH 7.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

character set conversion [message #310688]

Wed, 02 April 2008 01:41

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?

Report message to a moderator

Re: character set conversion [message #310694 is a reply to message #310688]

Wed, 02 April 2008 01:50

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Depends on which languages you have to support
2/ See #1

Regards
Michel

Report message to a moderator

Re: character set conversion [message #310713 is a reply to message #310688]

Wed, 02 April 2008 02:55

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

Report message to a moderator

Re: character set conversion [message #310714 is a reply to message #310688]

Wed, 02 April 2008 03:01

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

you had two questions. two answers are given.

Report message to a moderator

Re: character set conversion [message #310718 is a reply to message #310713]

Wed, 02 April 2008 03:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.
Yes, if you correctly use the database. Check with csscan.

Regards
Michel

Report message to a moderator

Re: character set conversion [message #310752 is a reply to message #310688]

Wed, 02 April 2008 05:20

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Step 0, run csscan to check data.

Regards
Michel

Report message to a moderator

Re: character set conversion [message #310760 is a reply to message #310688]

Wed, 02 April 2008 05:48

varu123
Messages: 754
Registered: October 2007

Senior Member

Surely yes

Report message to a moderator

Previous Topic:	SQLPLUS NOT FOUND
Next Topic:	Migrating from oracle 9i to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 00:40:24 CST 2024