-
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
Thanx
Sam
Life is a journey, not a destination!
-
OS AIX 4.3.2
DB ORA 8.1.5.0
US ASCII
Thanks all, :}
-
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.
Last edited by abhaysk; 07-18-2003 at 04:47 AM.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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 ! ! !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|