Home » Other » General » Dont get Japanese chars over Database Link
Dont get Japanese chars over Database Link [message #206724] Fri, 01 December 2006 04:38 Go to next message
Messages: 5
Registered: September 2005
Junior Member

Overview: I have two Oracle 9i databases, one in Japan and one in Germany. The one in Japan is Unicode capable but not the one in Germany. To display the Japan Kan-ji chars in the German-DB we are experiencing with fields of type NCHAR or NVARCHAR. It works fine so far if we copy and paste Kan-ji into the German-DB or Select/Insert from one table within German-DB to another table within German-DB.

Problem: If we try to Insert data over database link from Japanese-DB to German-DB we get upside down ? in the NCHAR and NVARCHAR fields.

Could someone please give me some hints to solve the problem? Google didn't give me good answers to my questions.

With kind regards and much thanks in advance,

Re: Dont get Japanese chars over Database Link [message #206845 is a reply to message #206724] Fri, 01 December 2006 13:47 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Try a google on:
oracle "database link" "character set conversion" corruption nchar
Previous Topic: Ansi/Sparc
Next Topic: What is the easy way to one can find the Oracle client version on his/her machine
Goto Forum:

Current Time: Tue Sep 26 09:47:50 CDT 2023