DB Character set

[abhaysk]

Originally posted by kris123
US ASCII

You can not store such HTML special chars in this characterset.

PS

WW04_DBA> select * from nls_database_parameters where  PARAMETER = upper('nls_characterset');

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               US7ASCII

WW04_DBA> select chr(241) from dual;

C
-
q

WW04_DBA> select chr(177) from dual;

C
-
1

Since this is 7 bit Characterset, max value in binary would be (1111111)=127, when ascii value is 128, it will effectively be 0 so all the literals starting from 128 to 255 will be same as 0 to 127.

Now just see how 8 bit character set will work.

TEST:ABHAY> select * from nls_database_parameters where  PARAMETER = upper('nls_characterset');

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               WE8MSWIN1252

TEST:ABHAY> select chr(241) from dual;

C
-
¤

TEST:ABHAY> select chr(177) from dual;

C
-
ñ

Hope this helps you.

Abhay.