Home » SQL & PL/SQL » SQL & PL/SQL » problem storing japanese text (oracle 10g)
problem storing japanese text [message #352166] Mon, 06 October 2008 07:18 Go to next message
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
Hi,
I am trying to store Japanese text in double bite varchar2 field.But the text is appeared as '???' instead of inserted japanese text.What settings I need to do in order to store Japanese text. I have Japanese fonts and charector set installed on my machine.

Regards,
Navneet
Re: problem storing japanese text [message #352177 is a reply to message #352166] Mon, 06 October 2008 08:50 Go to previous message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@Navneet,

I hope the following link helps:
NLS_LANG
Quote:

For instance, NLS_LANG set to AMERICAN_AMERICA.JA16SJIS will allow you to store Japanese providing the input data is truly JA16SJIS and if the database is also in a character set that can store Japanese like UTF8 or JA16SJIS



Hope this helps.
Regards,
Jo
Previous Topic: Confusing Error
Next Topic: ORA-00932 when converting column_expression from user_ind_expressions using to_lob
Goto Forum:
  


Current Time: Wed Dec 07 05:14:53 CST 2016

Total time taken to generate the page: 0.10022 seconds