Oracle character set display

[stressman]

Hy every one
I'm working on a windows 2003 server and Oracle 10g server standard
my windows OS is english and i add the Russian for keyboard.
the install of oracle was made with both the Russian ( CL8ISO8859P5 ), english languages.
I have created a database A with the character set
CL8ISO8859P5 and national character set UTF8
I created a database B with the character set
CL8MSWIN1251 and national character set UTF8

In each database i create a table with a field VARCHAR2(10)

under sqlplus i wrote :
insert into mytable values ('*****');
to write the stars i switch the keyboard in russian
my problem is that i m not sure about what is store in database when i try to insert
????? (with are the keys wxcvb)

in the database A oracle show in sqlplus request: ?????
in the database B oracle show in sqlplus request: O?NIE

is there one of the 2 database which store the right characters. How can i see the same character than those i try to insert (?????)

I hope i'm clear enought and all help or idea is wellcome Thanks to all

 

[SantaMufasa]

Stressman,

When one is having a problem with character-set display, a good way to confirm the exact (ASCII) contents of an expression is with the DUMP(<expression>) function:

select dump('?????????') from dual;

Typ=96 Len=9: <n>,<n>,<n>,<n>,<n>,<n>,<n>,<n>,<n>

...where "<n>" are each of the ASCII values for each of the Cyrillic characters in '?????????' ('Test'). If, instead, you see, "Typ=96 Len=9: 63,63,63,63,63,63,63,63,63" ("63" is the ASCII character of "?", then you know that there are character set problems.

Let use know, Stressman, whether your "select dump('?????????') from dual;" results in the correct ASCII values.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[stressman]

Hy SantaMufasa
I've tried the requiest and here are the results
I've inserted in both database the name
AZERTY which is in cyrillic something link a (Fi)(mu) Y KEH

in database A (CL8ISO8859P5 character set) i see
?????? Typ=1 Len=6 : 63,63,63,63,63,63

in database B (CL8MSWIN1251 character set) i see
OYOEAI Typ=1 Len=6 : 79,89,79,69,65,73

As i haven't got two times the same character in the name it looks like both choices are wrong.

Can you help me to make the right Oracle 10g install configuration to save and display Cyrillic character set with an US Windows 2003 OS.

Thank for all your help and interrest.

 

[SantaMufasa]

Actually, Stressman, our local resident expert on Cyrillic-character storage and display is Sem (Dima) [he is in the Ukraine]. Sem, can you offer help to Streesman?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[sem]

Stressman, what is your client-side character set (the third part of NLS_LANG tnvironment variable)? It must support cyrillic characters (ISO8859P5, CL8MSWIN1251, CL8KOI8R or UTF). If you're connecting from windows, you should choose CL8MSWIN1251. In general for Windows-based systems working with Russsian databases it's recommended NLS_LANG=RUSSIAN_CIS.CL8MSWIN1251

Regards, Dima

http://seminihin.narod.ru

 

[stressman]

Now the NLS_LANG format is AMERICAN_AMERICA.CL8MSWIN1251

How to modify it ? do i just have to change the regitry key for the right value? or do i have to make a new install ?

Thanks for your help SantaMufasa and Sem

 

[sem]

Registry settings are enough. But be sure that you've made changes under corerct key (if you have multiple Oracle homes). Actually your currens NLS_LANG denotes that all Oracle messages would be in English, American default date and number format masks are in use and cyrillic characters may be processed. Are you still experiencing any charset issues?

Regards, Dima

http://seminihin.narod.ru