Home » Developer & Programmer » Precompilers, OCI & OCCI » unicode character set and pro*c (9.0.1,10.2.0.1)
unicode character set and pro*c [message #311726] Sun, 06 April 2008 02:18 Go to next message
varu123
Messages: 754
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 Go to previous messageGo to next message
varu123
Messages: 754
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 Go to previous messageGo to next message
varu123
Messages: 754
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]

Report message to a moderator

Re: unicode character set and pro*c [message #311766 is a reply to message #311761] Sun, 06 April 2008 12:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 Go to previous messageGo to next message
varu123
Messages: 754
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 Go to previous message
varu123
Messages: 754
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?
Previous Topic: Proc object file recompilation in different linux
Next Topic: ORA-24343: user defined callback error
Goto Forum:
  


Current Time: Thu Mar 28 14:42:19 CDT 2024