Re: Default characterset for database on Windows Servers

On Fri, 08 Sep 2006 23:47:27 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>dbaplusplus_at_hotmail.com wrote:
>> DA Morgan wrote:
>>> dbaplusplus_at_hotmail.com wrote:
>>>
>>>> Are there any advantages to using WE8NSWIN1252 windows? Why Oracle
>>>> decided to use
>>>> A different default database character set (not NCHAR character set is
>>>> same on Windows and UNIX),
>>> I can't speak with respect to 9i on this but there are features in 10g
>>> that will not work with UTF8: Among them Advanced Rewrite.
>>> --
>>> Daniel Morgan
>>> University of Washington
>>> Puget Sound Oracle Users Group
>>
>> This looks like some bug introudced in 10GR2 which should get fixed.
>> UTF8 is still default chacater set in DBCA on UNIX. There must be other
>> reason for using WE8NSWIN1252.
>
>Eurocentrism? ;-)

Things change slow at Oracle. IIRC correctly this default characterset was introduced in 8i.
Before that the default was US7ASCII, and the only way to change to an European characterset, was to include support for an European language, like Dutch.
At the same time the default on Unix, was still US7ASCII.

--
Sybrand Bakker, Senior Oracle DBA