NLS QUESTION - WE8ISO8859P1 - Russian Cyrillic ???
Kristy
We have been using the WE8ISO8859P1 character set in our Oracle
database with great success with our French, German, U.K., etc. users
until now...
Our test user in Russia enters and sees Cyrillic characters on the
screen (Windows) but after she saves and retrieves the record, the
Cyrillic characters are gone. Is it possible to have different
clients with different character sets all using the same database???
Thanks in advance,
Kristy
Oracle DBA
Oleg Tsibulnyak
Use for database UNICODE character set (UTF8) and
CL8MSWIN1251 (or RU8PC866, or KOI8R, etc) for russian clients.
--
Regards,
Oleg Tsibulnyak
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Frank Puechl
I am developing an application for a Japanese customer. We are using Windows
(95 and NT) clients, a HP-UX server and Oracle 7.3.4. To be able to work
with the Japanese characters we are using the following character sets, for
the client 'JA16SJIS' and for the server 'JA16EUC'.
Using these character sets we are able to store English and Japanese
characters. Special German characters cannot be used. If you are running
Oracle8 you are able to use the UNICODE character set that supports all
characters.
The problem with different character sets is the conversion from the client
to the server - you must have fitting sets to avoid loss of data.
Good Luck
Frank Puechl
Technology Consultant
debis Systemhaus Dienstleistungen GmbH
Insurance International
Kristy <nospam...@home.com> wrote in message
news:3749c561...@client.ce.news.psi.net...
Elias A. Kuzkin
Kristy wrote in message <3749c561...@client.ce.news.psi.net> ...
>Hi Gang:
>
>We have been using the WE8ISO8859P1 character set in our Oracle
>database with great success with our French, German, U.K., etc. users
>until now...
>
>Our test user in Russia enters and sees Cyrillic characters on the
>screen (Windows) but after she saves and retrieves the record, the
>Cyrillic characters are gone. Is it possible to have different
>clients with different character sets all using the same database???
>
>Thanks in advance,
>Kristy
>Oracle DBA
Dear Kristy,
Your russian client should run regedit,
switch to HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE and find parameter called
NLS_LANG (somewhere in ORACLE_HOMES) and set it to AMERICAN_CIS.CL8MSWIN1251
or RUSSIAN_CIS.CL8MSWIN1251 (this is most probable character set, but it may
vary - client design dependant, another alternative is CL8ISO8859P5 which is
less used at Windows, mostly at UNIX-systems).
Best regards,
Elias A. Kuzkin, Oracle Developer,
Corvus International LLC, Moscow, Russian Federation,
d...@corvus.ru
Mich
Kristy пишет в сообщении <3749c561...@client.ce.news.psi.net> ...
>Hi Gang:
>
>We have been using the WE8ISO8859P1 character set in our Oracle
>database with great success with our French, German, U.K., etc. users
>until now...
>
>Our test user in Russia enters and sees Cyrillic characters on the
>screen (Windows) but after she saves and retrieves the record, the
>Cyrillic characters are gone. Is it possible to have different
>clients with different character sets all using the same database???
Yes, you can store russian letters in the database generated with this
charset, and it will be all right
if your russian tester will have NLS_LANGUAGE=xxx_xxx.WE8ISO8859P1 on his
workstation.
But, possibly there will be a problems with sorts, because this charset
does not really support russian charset. Using different charsets on the
same database os possible (AFAIK) only if you are using unicode charset on
database, or ORACLE8, which supports 2 charsets on the same database.
Stilian Elenkov
>
> Hi Kristy,
>
> I am developing an application for a Japanese customer. We are using Windows
> (95 and NT) clients, a HP-UX server and Oracle 7.3.4. To be able to work
> with the Japanese characters we are using the following character sets, for
> the client 'JA16SJIS' and for the server 'JA16EUC'.
> Using these character sets we are able to store English and Japanese
> characters. Special German characters cannot be used. If you are running
> Oracle8 you are able to use the UNICODE character set that supports all
> characters.
>
> The problem with different character sets is the conversion from the client
> to the server - you must have fitting sets to avoid loss of data.
>
> Good Luck
> Frank Puechl
> Technology Consultant
> debis Systemhaus Dienstleistungen GmbH
> Insurance International
>
> Kristy <nospam...@home.com> wrote in message
> news:3749c561...@client.ce.news.psi.net...
> >
> > We have been using the WE8ISO8859P1 character set in our Oracle
> > database with great success with our French, German, U.K., etc. users
> > until now...
> >
> > Our test user in Russia enters and sees Cyrillic characters on the
> > screen (Windows) but after she saves and retrieves the record, the
> > Cyrillic characters are gone. Is it possible to have different
> > clients with different character sets all using the same database???
> >
> > Kristy
> > Oracle DBA
You can use UTF8 (UNICODE) which can store all types of characters. The
code is AL24UTFFSS.
This is available in Oracle 7 as well. We are using it to store records
in 35 (and more) different languages, including Arabic, Hebrew, CJK,
Japanese Russian, Greek etc.
Stilian
--
Linus Torvalds on Microsoft and software development:
"... if it's a hobby for me and a job for you, why are you doing such a
shoddy job of it?"