| unicode character set and pro*c [message #311726] |
Sun, 06 April 2008 02:18  |
varu123
Messages: 634
Registered: October 2007 |
Senior Member |
|
|
I created a database with AL32UTF8 character set.
Then i created a table with a column varchar2 type.
After that i tried to insert hindi data.[copy/paste from internet]
but when i select the query "?????" appears instead of hindi charcaters.
Secondly,as reports are printed out from data generated through proc,what changes needs to be done in Proc code to recognize hindi characters so that they could print out as required.
|
|
|
| Re: unicode character set and pro*c [message #311728 is a reply to message #311726 ] |
Sun, 06 April 2008 02:47  |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| Quote: | After that i tried to insert hindi data.[copy/paste from internet]
|
Where do you paste your text? The problem comes from this client application or client configuration (NLS_LANG).
| Quote: | when i select the query "?????" appears instead of hindi charcaters.
|
Same thing. Does your client application supports hindi? Does your client NLS_LANG set for hindi? Are you data in database hindi or are they "?", dump the column?
| Quote: | what changes needs to be done in Proc code to recognize hindi characters so that they could print out as required.
|
None. It is a problem of your OS not your program. Does your OS configure for this character set? Does your NLS_LANG set to suppport this character set?
Regards
Michel
|
|
|
| Re: unicode character set and pro*c [message #311754 is a reply to message #311726 ] |
Sun, 06 April 2008 09:47 |
varu123
Messages: 634
Registered: October 2007 |
Senior Member |
|
|
| Quote: | Where do you paste your text? The problem comes from this client application or client configuration (NLS_LANG).
|
I am testing it on my local machine.
I copy/pasted hindi words from a hindi website to see what happens.
I have set nls_lang to hindi.
This is what i see
Create table a (n varchar2(10));
insert into a values('????');
select * from a;
????
|
|
|
| Re: unicode character set and pro*c [message #311757 is a reply to message #311754 ] |
Sun, 06 April 2008 10:49 |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
To where do you paste? Notepad? vi? wordpad? word? sqlplus? ???
Are all configurations OK?
Regards
Michel
|
|
|
| Re: unicode character set and pro*c [message #311761 is a reply to message #311726 ] |
Sun, 06 April 2008 11:43 |
varu123
Messages: 634
Registered: October 2007 |
Senior Member |
|
|
sqlplus
insert into a values('here i paste');
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0
I changed nls_language to hindi in init parameter.
SQL> show parameter nls_lang
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string Hindi
[Updated on: Sun, 06 April 2008 11:48]
|
|
|
| Re: unicode character set and pro*c [message #311766 is a reply to message #311761 ] |
Sun, 06 April 2008 12:25 |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Keep your line in 80 characters and this include ening spaces.
Regards
Michel
|
|
|
| Re: unicode character set and pro*c [message #311767 is a reply to message #311726 ] |
Sun, 06 April 2008 12:40 |
varu123
Messages: 634
Registered: October 2007 |
Senior Member |
|
|
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0
SQL> show parameter nls_lang;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------
nls_language string Hindi |
|
|
| Re: unicode character set and pro*c [message #311888 is a reply to message #311726 ] |
Mon, 07 April 2008 04:58 |
varu123
Messages: 634
Registered: October 2007 |
Senior Member |
|
|
Does sqlplus support hindi characters?
Even if all the nls settings are appropriate,sqlplus shows "????".
Then how to see data in other language then english?
|
|
|
]
Members
Search
Help
Register
Login
Home
