Re: exp character set, Oracle 9i win 2000

Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<2ms34v8o20g4etgiprjhuc28elbulj4blo_at_4ax.com>...
> 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

Sybrand,

thanks much, that is just what I was looking for. looks like I'll just need a registry script that changes the nls_lang in the 8.1.7 home on the client for places where we don't see a reason to upgrade to a 9.2 client.

Paul Received on Thu Feb 06 2003 - 18:01:07 CST