Hello Viktor
I think that the problem is not with oracle.
If you have the same nls_lang on the client and the
database
oracle will not do translation but will work on the
principal
of GIGO (garbage in, garbage out), meaning what you put
in
is what you get.
You need a program on the client side that can display the
special
characters that you get in your data.
We are working also with we8iso8859p1 and we store and
retrieve
Hebrew letters with no problems.
Yechiel Adar Mehish
----- Original Message -----
Sent: Thursday, October 17, 2002 10:10
PM
Subject: Displaying Foreign
characters
Hello all,
Is there a simple way to display correctly foreign characters
primarily found in name and address records? Currectly, NLS_LANGUAGE =
AMERICAN in init.ora and NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 in the
registry on client side. Problem is is that name and address records may have
characters like "a" with 2 dots on top, and many others, and when
querying the db, obviously they're not displayed correctly.
Is there an easy way to do this reql quick?
Thanks much in advance!
Do you Yahoo!? Faith Hill - Exclusive
Performances, Videos, & more faith.yahoo.com
|