Home » RDBMS Server » Server Administration » multiByte characters insertion/selection from oracle database problems (oracle 10g, OS:Red Hat Enterprise Linux WS release 4 (Nahant Update 2))
multiByte characters insertion/selection from oracle database problems [message #423941] Tue, 29 September 2009 05:59 Go to next message
Messages: 1
Registered: September 2009
Location: tunisia
Junior Member

Posted: 29 sept. 2009 02:28
Click to edit this message... Edit Click to report abuse... Click to reply to this thread Reply
Hi ,
i must supoport some character sets which are: Chinese, Hebrew, Japanese, Koean.
I have done some researchs and these are the results found:
1- oracle provide NCAHR and NVARCHAR2 types for attributes to be persisted in multibyte characters,
2- we must set NLS_LANG environment variable used to define language, territory and character set properties: export NLS_LANG=Japanese_Japan.JA16SJIS for japanese charcter..

To test insertion/retrieving of multibyte characters, I have:
1- create a new table called 'TEST' composed of one column which type is NVARCHAR2
2- export NLS_LANG=Japanese_Japan.JA16SJI
3- restart Oracle
4- insert into TEST a new row in japanese character set via a java porogram
5- if we select from TEST table we retrieve exclamation points set: ¿¿¿¿¿¿ Confused
I think that we need more configurations else. what do you think ?
thanks in advance Smile
--Best Regards,
Re: multiByte characters insertion/selection from oracle database problems [message #425925 is a reply to message #423941] Tue, 13 October 2009 02:48 Go to previous message
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
check following...
This is what you are using...
JA16SJIS Shift-JIS 16-bit Japanese

I would suggest you to use

UTF8 :- Unicode 2.0 UTF-8 Universal character set

hope it helps....

Previous Topic: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504
Next Topic: TableSpace Information (merged)
Goto Forum:

Current Time: Wed Aug 16 21:04:09 CDT 2017

Total time taken to generate the page: 0.11469 seconds