| setting appropriate nls_lang [message #312507] |
Wed, 09 April 2008 01:37  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
10.2.0.1,RHEL 4
I craeted a database with AL32UTF8 character sett and AL16UTF16 national character set.
According to
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410565
I set
LC_ALL=utf-8
nls_lang=HINDI_INDIA.UTF8
I imported table containing hindi data.
import done in UTF8 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses US7ASCII character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
I can login the database but when i query table containing hindi data
Its showing
small rectangular boxes as the rows.
I want to display hindi data in sqlplus in linux.
|
|
|
|
|
|
| Re: setting appropriate nls_lang [message #312518 is a reply to message #312507] |
Wed, 09 April 2008 02:17  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I spooled teh file and saw in vi editor,it is showing in hindi.
As whether sqlplus supports Hindi,from the link i posted it is written
| Quote: | Is iSQL*Plus the only UTF8/Unicode enabled client we support?
On Windows OS, yes, On Unix OS's, no. All the database utilties, including Import, Export, SQL*Loader, SQL*Plus, can act as a UTF-8 client if the OS locale is UTF-8 (e.g., en_US.UTF-8 on Linux) and NLS_LANG character set is set to UTF8 or AL32UTF8.
|
[Updated on: Wed, 09 April 2008 02:17] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
