DB Character set

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,

Hi,

did u check it properly,

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

Srini

I am able to insert the same charecter.

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

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

Sam

OS AIX 4.3.2
DB ORA 8.1.5.0
US ASCII

Thanks all, :}

Quote:

---

Originally posted by kris123
US ASCII

---

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

PS

Code:

---

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.

Code:

---

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.

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 ! ! !