Re: NLS question
- From: Jimmy Brock <jimmybrock@xxxxxxxxx>
- To: Martin Berger <martin.a.berger@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Sun, 13 Mar 2011 08:08:54 -0700
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
Other related posts:
