Re: odbc>=8.1 and the broken euro symbol

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 17 Sep 2005 12:39:38 +0200
Message-ID: <dggrag$7u2$1@news4.zwoll1.ov.home.nl>

Frank van Bortel wrote:

> jan rosinowski wrote:
> 

>>hi,
>>
>>i need to retrieve the euro-character from a database but
>>
>> select '@µäöü߀' f from dual
>>
>>returns
>>
>> '@µäöüß?' (or sometimes a turned questionmark)
>>
>>the oracle odbc-driver translation option is set to 0 which is the
>>default.
>>
>>what's going on here?

> 
> 
> NLS_LANG issue - what is your value?
> WE8ISO8859P1 is *not* going to work, WE8MSWIN1252
> is your best shot.

Ah - it's your client, then.
Basically, Sybrand gave you the answer; let me demonstrate:

I changed the Properties of this command session from using raster type font (system) to using Lucinda Console TT. This is in the Properties->Font tab.

D:\>chcp
Actieve codetabel: 437

Not what one would expect... codepage 437... This is a Dutch system. Let's change to Western European Windows:

D:\>chcp 1252
Actieve codetabel: 1252

D:\>sqlplus system/manager_at_o920

SQL*Plus: Release 10.1.0.2.0 - Production on Sat Sep 17 12:32:38 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> select '@µäöü߀' f from dual ;

F

---

@µäöü߀

SQL> / F

---

@µäöü߀

SQL> host chcp 437
Actieve codetabel: 437

SQL> / F

---

@╡Σ÷ⁿ▀Ç

SQL>

-- 

Changing the properties of the command session is even more dramatic...

Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Sat Sep 17 2005 - 05:39:38 CDT