DB Character set

[kris123]

Hi Friends,

Our Applications require the letter "ñ" to be inputed and saved
in the Database, but when I inserted this char, it was not
saved. How do I configure my database to accept this one?

Thanks,

[Srinivas_Sharma]

Hi,

did u check it properly,

I am able to save it in a table and it displays properly.

Srini

[shashikumar]

I am able to insert the same charecter.

Please check out the Data type used to store the data for that particular column.

[sambavan]

Can you give me some more information on the database version, OS, and the National Language Character set.

Sam

[kris123]

OS AIX 4.3.2
DB ORA 8.1.5.0
US ASCII

Thanks all, :}

[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.

[DaPi]

You will need to change the character set of the db - documentation here.
WE8ISO8859P1 is a common choice for European languages.

! ! ! Test this since you will have trouble going back if you choose the wrong char set ! ! !