Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 25 Jul 2007 14:53:06 GMT
Message-ID: <1185375182.101007@proxy.dienste.wien.at>

Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:
>>>> So you are telling us that you used US7ASCII to store German umlauts?
>>>> This is just wrong. US7ASCII is just 0x00 -> 0x7F but the characters
>>>> you are talking about are 0x80 -> 0xFF and so cannot be correctly
>>>> stored in an US7ASCII character set column.
>>>>

[...]
>>
>> Still it is the wrong character set. It's like telling oracle the the
>> charset is UTF8 and then inserting WE8ISO8859P1 -- it *should* work if
>> you lie to Oracle about the NLS_LANG character sets, but it's still
>> wrong and will get you (it got me) into trouble.
>> Martin

> 
> What would the right thing be then? DB char set = server NLS settings =
> client NLS settings? Just as dangerous and wrong.

The right thing would be to do an ALTER DATABASE CHARACTER SET to change the database to the encoding of the data that are stored in it.

Then set NLS_CHAR to the character set that the client expects.

See Metalink note 66320.1.

Yours,
Laurenz Albe Received on Wed Jul 25 2007 - 09:53:06 CDT