Oracle-L: Re: AW: Strange problem with charactersets

From: Sergey V Dolgov <dsv_at_pptus.oilnet.ru>
Date: Wed, 15 May 2002 17:58:33 -0800
Message-ID: <F001.00461D9A.20020515175833@fatcity.com>

Hello ,

Compare registry branches between your computers:

HKLM\System\CurrentControlSet\Control\Nls\
HKLM\System\CurrentControlSet\Control\Nls\CodePage
HKLM\System\CurrentControlSet\Control\Nls\Language

Wednesday, May 15, 2002, 9:43:27 PM, you wrote:

vsid> My problem is, that everything works fine with Oracle 8.1.5 clients, but not vsid> with oracle 8.1.7 clients using same registry and NLS settings.

vsid> regards

vsid> Volker Schoen 
vsid> E-Mail: mailto:v.schoen_at_inplan.de <mailto:v.schoen_at_inplan.de>  
vsid> http://www.inplan.de <http://www.inplan.de/>  

vsid> -----Ursprüngliche Nachricht-----
vsid> Von: Nicolai Tufar [mailto:ntufar_at_apb.com.tr] 
vsid> Gesendet: Mittwoch, 15. Mai 2002 16:03

vsid> An: Multiple recipients of list ORACLE-L vsid> Betreff: Re: Strange problem with charactersets

vsid> Unfortunately the only solution is to recreate the database in German
vsid> character set.
vsid> Oracle is very strict in this respect. Database character set once chosen
vsid> can not 
vsid> be changed.

vsid> ----- Original Message -----

vsid> To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> vsid> Sent: Wednesday, May 15, 2002 4:13 PM

vsid> Hi list,

vsid> I have a strange problem with charctersets, character display.

vsid> I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On
vsid> clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now
vsid> I've installed a Windows 2000 PC with Oracle 8.1.7 client and here a the
vsid> strange behaviours.

vsid> Oracle 8.1.7 client shows instead of öäüß (german special characters) oau?.
vsid> I've never seen this. Normally the special characters would be shown as

vsid> unreadable signs. On client we tried these different NLS settings, but vsid> nothing works:

vsid> NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 
vsid> NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 
vsid> NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 
vsid> NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 
vsid> NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15

vsid> Windows 2000 territory settings are all to german.

vsid> All infos are welcome.

vsid> Volker Schoen 
vsid> E-Mail:  <mailto:v.schoen_at_inplan.de> v.schoen_at_inplan.de 
vsid>  <http://www.inplan.de> http://www.inplan.de

--

Best regards,

 Sergey                            mailto:dsv_at_pptus.oilnet.ru

--

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

Author: Sergey V Dolgov
INET: dsv_at_pptus.oilnet.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Wed May 15 2002 - 20:58:33 CDT