Re: what characterset to use?

On Wed, 22 Aug 2007 08:39:02 -0700, Ben <balvey_at_comcast.net> wrote:

>One other thought. How could it be possible to guarantee that you
>would never corrupt your data in a WE8MSWIN1252 database character set
>or any other multibyte character set?
>

WE8MSWIN1252 is a *single* byte characterset. Please read your manuals.
>You don't really have control over what character set all the clients
>connect with, do you? If you have a client that uses US7ASCII and they
>select then update based on results, you could potentially corrupt all
>your data. no?

Incorrect again. If your database has been set up correctly (which is database characterset matches the OS characterset or is supported by the OS AND NLS_LANG has been set correctly) the US7ASCII data will get converted upon arrival.
If your client NLS_LANG is US7ASCII AND your database NLS_LANG is US7ASCII, no conversion will take place. THIS will 'corrupt' your data.

-- 

Sybrand Bakker
Senior Oracle DBA