Oracle-L: Re: Displaying Foreign characters

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Fri, 18 Oct 2002 01:19:46 -0800
Message-ID: <F001.004ED120.20021018011946@fatcity.com>

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 ----- From: Viktor To: Multiple recipients of list ORACLE-L 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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Yechiel Adar
INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 18 2002 - 04:19:46 CDT