OraFAQ Forum: Server Administration » Cyrillic Character Set Problem

Home » RDBMS Server » Server Administration » Cyrillic Character Set Problem (Oracle 10G, Solaris 10)

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

Cyrillic Character Set Problem [message #521672]

Wed, 31 August 2011 22:48

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hi all,

I'm try to import a table of data (character set: CL8ISO8859P5) to another database (character set: AL32UTF8) using exp/imp utility.
After the import, all Cyrillic text was corrupted!

How to solve this issue?

Report message to a moderator

Re: Cyrillic Character Set Problem [message #521673 is a reply to message #521672]

Wed, 31 August 2011 22:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>How to solve this issue?
I am not sure exactly what the issue really is.

The basic question that needs to be answered is as follows:

Is the problem one of data storage or data presentation; since they can look the same.

SELECT ASCIISTR(CYRILLIC_COL) FROM CYRILLIC_TBL WHERE ID =1;

modify SQL above to meet what you have, then run it.

COPY & PASTE the SQL SELECT & results, then PASTE all back here.

this will show which problem you have.

Report message to a moderator

Re: Cyrillic Character Set Problem [message #521674 is a reply to message #521673]

Wed, 31 August 2011 23:03

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hi BlackSwan,

Quote:

SELECT ASCIISTR(CYRILLIC_COL) FROM CYRILLIC_TBL WHERE ID =1;

I execute above query. The result is very interest: \0404\0410\0412\041E...

What is mean the query result?

Report message to a moderator

Re: Cyrillic Character Set Problem [message #521675 is a reply to message #521674]

Wed, 31 August 2011 23:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I execute above query. The result is very interest: \0404\0410\0412\041E...
>What is mean the query result?

I read it to mean that the CYRILLIC characters are in the DB.

I suspect you simply have a data presentation problem.
The client/OS is mis-configured that prevents proper display.

Report message to a moderator