Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g4FE8GL22902 for ; Wed, 15 May 2002 10:08:16 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id HAA55565; Wed, 15 May 2002 07:15:35 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 004611DD; Wed, 15 May 2002 07:03:32 -0800 Message-ID: Date: Wed, 15 May 2002 07:03:32 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Szecsy Tamas Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Szecsy Tamas Subject: RE: Strange problem with charactersets Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1FC18.0AFA6E20" ------_=_NextPart_001_01C1FC18.0AFA6E20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >From Oracle 8i and up you do not have to recreate the database, you = just have to issue an alter command and reload the data.=20 =20 Unfortunately this would not help Volker any further. =20 Tamas Szecsy -----Original Message----- Sent: Wednesday, May 15, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Unfortunately the only solution is to recreate the database in German character set. Oracle is very strict in this respect. Database character set once = chosen can not=20 be changed. ----- Original Message -----=20 To: Multiple recipients of list ORACLE-L = Sent: Wednesday, May 15, 2002 4:13 PM Hi list,=20 I have a strange problem with charctersets, character display.=20 I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. = On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. = Now I've installed a Windows 2000 PC with Oracle 8.1.7 client and here a = the strange behaviours. Oracle 8.1.7 client shows instead of =F6=E4=FC=DF (german special = characters) oau?. I've never seen this. Normally the special characters would be shown as unreadable signs. On client we tried these different NLS settings, but nothing works: NLS_LANG=3DGERMAN_GERMANY.WE8ISO8859P1=20 NLS_LANG=3DGERMAN_GERMANY.WE8ISO8859P15=20 NLS_LANG=3DGERMAN_GERMANY.WE8MSWIN1252=20 NLS_LANG=3DAMERICAN_AMERICA.WE8ISO8859P1=20 NLS_LANG=3DAMERICAN_AMERICA.WE8ISO8859P15=20 Windows 2000 territory settings are all to german.=20 All infos are welcome.=20 Volker Schoen=20 E-Mail: v.schoen@inplan.de=20 http://www.inplan.de=20 ------_=_NextPart_001_01C1FC18.0AFA6E20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Strange problem with charactersets
From  Oracle 8i and up you do not have = to recreate=20 the database, you just have to issue an alter command and reload the = data.=20
 
Unfortunately this would not help Volker any = further.
 
Tamas=20 Szecsy
-----Original Message-----
From: Nicolai Tufar=20 [mailto:ntufar@apb.com.tr]
Sent: Wednesday, May 15, 2002 = 4:03=20 PM
To: Multiple recipients of list = ORACLE-L
Subject: Re:=20 Strange problem with charactersets

Unfortunately the only solution is = to recreate=20 the database in German character set.
Oracle is very strict in this = respect. Database=20 character set once chosen can not
be changed.
----- Original Message -----
From:=20 v.schoen@inplan.de
To: Multiple=20 recipients of list ORACLE-L
Sent: Wednesday, May 15, = 2002 4:13=20 PM
Subject: Strange problem = with=20 charactersets

Hi list,

I have a strange problem with charctersets, = character=20 display.

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

Oracle 8.1.7 client shows instead of = =F6=E4=FC=DF (german=20 special characters) oau?. I've never seen this. Normally the = special=20 characters would be shown as unreadable signs. On client we tried = these=20 different NLS settings, but nothing works:

NLS_LANG=3DGERMAN_GERMANY.WE8ISO8859P1 =
NLS_LANG=3DGERMAN_GERMANY.WE8ISO8859P15 =
NLS_LANG=3DGERMAN_GERMANY.WE8MSWIN1252 =
NLS_LANG=3DAMERICAN_AMERICA.WE8ISO8859P1 =
NLS_LANG=3DAMERICAN_AMERICA.WE8ISO8859P15

Windows 2000 territory settings are all to=20 german.

All infos are welcome.

Volker Schoen =
E-Mail: v.schoen@inplan.de
http://www.inplan.de=20


------_=_NextPart_001_01C1FC18.0AFA6E20-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: tszecsy@GEOMETRIA.hu 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@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).