language in oracle 10g [message #590298] |
Tue, 16 July 2013 22:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/571c2c09b1b177481a003344d1584634?s=64&d=mm&r=g) |
clementstore
Messages: 11 Registered: December 2011
|
Junior Member |
|
|
Hello there,
I have an Oracle DB's charset configured for Korean language and things in there are English and KOrean and they are working fine.
If i try to import a txt file with Chinese chararcters into the DB. It doesnt show correctly on query.
Is there any way I can solve this ? Since I find that there are many charset / NLS language options througout DB.
I read from others that they have the following response. Any alternative beside changing the whoel DB charset ?
thanks
Clement
Recreate the database with the correct character set
Convert the database to AL32UTF8. Documentation link
Change the databases National Character Set to AL32UTF8 & change your application to use NVARCHAR2()/NCHAR() datatypes instead of VARCHAR2() (documented at the same link as above)
|
|
|
|
|
|
|
|