Re: exp character set, Oracle 9i win 2000

From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 06 Feb 2003 20:36:29 +0100
Message-ID: <3E42B93D.6040701@netscape.net>

Sybrand Bakker wrote:
> On 5 Feb 2003 17:46:53 -0800, drak0nian_at_yahoo.com (Paul Drake) wrote:
>
>

>>I'd like to solicit people's opinions on whether its better to dumb
>>down the 9.2 clients - alter their registry entry to WE8ISO8859P1 - or
>>to plan on changing the database character set to WE8MSWIN1252 when we
>>migrate from 8.1.7 to 9.2.

>
>
>
> Keep in mind MSWIN1252 is NOT (I repeat NOT) a superset of ISO8859P1,
> and MSWIN1252 contains the euro symbol.
> You could avoid a lot of trouble by using MSWIN1252 rightaway
> everywhere. You won't be capable to change the characterset using
> alter database commands later if you set it to ISO8859P1.
> Oracle didn't invent this, the ISO couldn't agree about the location
> of the euro symbol in ISO8859P1.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

So they invented ISO8859P15, which M$ completely ignores. With the result that a EUro will be mapped to an upside-down question mark in any Windows environment.

Frank Received on Thu Feb 06 2003 - 13:36:29 CST