Re: exp character set, Oracle 9i win 2000

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 06 Feb 2003 06:32:30 +0100
Message-ID: <2ms34v8o20g4etgiprjhuc28elbulj4blo@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

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 05 2003 - 23:32:30 CST