Home » RDBMS Server » Server Administration » language in oracle 10g (Oracle Std 10g with windows server 2008 std)
language in oracle 10g [message #590298] Tue, 16 July 2013 22:29 Go to next message
clementstore
Messages: 5
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)
Re: language in oracle 10g [message #590299 is a reply to message #590298] Tue, 16 July 2013 22:35 Go to previous messageGo to next message
BlackSwan
Messages: 23070
Registered: January 2009
Senior Member
Only proper way to establish database character set is at DB creation.


>If i try to import a txt file with Chinese chararcters into the DB
If you simply display (TYPE textfile.txt) the file that contains the Chinese characters, are they properly displayed?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: language in oracle 10g [message #590300 is a reply to message #590299] Tue, 16 July 2013 22:45 Go to previous messageGo to next message
clementstore
Messages: 5
Registered: December 2011
Junior Member
Hello Blackswan,

Thanks for your reply.

If i try to import a txt file with Chinese chararcters into the DB. It doesnt show correctly on query and display.
It shows question marks : ??????

Any idea...?

cheers,
Clement
Re: language in oracle 10g [message #590301 is a reply to message #590300] Tue, 16 July 2013 22:48 Go to previous messageGo to next message
BlackSwan
Messages: 23070
Registered: January 2009
Senior Member
If you simply display (TYPE textfile.txt) the file that contains the Chinese characters, are they properly displayed?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: language in oracle 10g [message #590302 is a reply to message #590301] Tue, 16 July 2013 22:54 Go to previous messageGo to next message
clementstore
Messages: 5
Registered: December 2011
Junior Member
THe file itself is ok ofcos. ;D Just the import action turn the data into question marks. ???????
Re: language in oracle 10g [message #590308 is a reply to message #590302] Wed, 17 July 2013 00:03 Go to previous message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Expected behaviour.

Recreate the database with AL32UTF8 character set.

Regards
Michel
Previous Topic: Unused columns
Next Topic: Can Oracle Home and database instance be owned by different users?
Goto Forum:
  


Current Time: Sat Nov 29 00:30:17 CST 2014

Total time taken to generate the page: 0.08214 seconds