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,
Printable View
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, :}
You can not store such HTML special chars in this characterset.Quote:
Originally posted by kris123
US ASCII
PS
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.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
Now just see how 8 bit character set will work.
Hope this helps you.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
-
ñ
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 ! ! !