Re: NLS question

From: Jimmy Brock <jimmybrock_at_gmail.com>
Date: Sun, 13 Mar 2011 08:08:54 -0700
Message-ID: <AANLkTi=BjxEW3eNrfskHCs52-AqKJ5X=NfOH3+hxE7E6_at_mail.gmail.com>

Jimmy,

> NLS_CHARACTERSET=US7ASCII means 256 characters see http://www.asciitable.com/
>>
>>
> that's not 100% true.
> only the first 127 char are defined.
> That's what the 7 is standing for - ASCII 7-bit America
>
> Yes, you can trick the DB to store some 8-bit values. This will bring you
> into a huge load of fun.
>
> sorry,
> Martin
>

Good catch! I don't why I typed 256 characters. Actually, it is 128 characters - chr(0) to chr(127).

I checked MOS and Oracle recommends using character set WE8MSWIN1252, which is a superset of WE8ISO8859P1, P9, P15 and US7ASCII.

-- 
Jimmy Brock

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Mar 13 2011 - 10:08:54 CDT

This message: [ Message body ]
Next message: Gokul Kumar Gopal: "Index - Partition design confusion.."
Previous message: Mayen.Shah_at_lazard.com: "Re: Grants on a remote table?"
In reply to: Martin Berger: "Re: NLS question"
Next in thread: De DBA: "Re: NLS question"
Reply: De DBA: "Re: NLS question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message