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: need help for displaying full string in filter dropdown box
Goto Forum:

Current Time: Sat Aug 19 23:09:42 CDT 2017

Total time taken to generate the page: 0.21131 seconds