OraFAQ Forum: Server Administration » language in oracle 10g

Home » RDBMS Server » Server Administration » language in oracle 10g (Oracle Std 10g with windows server 2008 std)

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

language in oracle 10g [message #590298]

Tue, 16 July 2013 22:29

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)

Report message to a moderator

Re: language in oracle 10g [message #590299 is a reply to message #590298]

Tue, 16 July 2013 22:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: language in oracle 10g [message #590300 is a reply to message #590299]

Tue, 16 July 2013 22:45

clementstore
Messages: 11
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

Report message to a moderator

Re: language in oracle 10g [message #590301 is a reply to message #590300]

Tue, 16 July 2013 22:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: language in oracle 10g [message #590302 is a reply to message #590301]

Tue, 16 July 2013 22:54

clementstore
Messages: 11
Registered: December 2011

Junior Member

THe file itself is ok ofcos. ;D Just the import action turn the data into question marks. ???????

Report message to a moderator

Re: language in oracle 10g [message #590308 is a reply to message #590302]

Wed, 17 July 2013 00:03

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

Senior Member
Account Moderator

Expected behaviour.

Recreate the database with AL32UTF8 character set.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 07:25:22 CDT 2025