character set conversion [message #310688] |
Wed, 02 April 2008 01:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #310713 is a reply to message #310688] |
Wed, 02 April 2008 02:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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/
|
|
|
|
|
Re: character set conversion [message #310719 is a reply to message #310688] |
Wed, 02 April 2008 03:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|