Diacritical characters in JA16SJIS database?

From: Brett <loligo_loligo_at_hotmail.com>
Date: 10 Oct 2001 15:50:16 -0700
Message-ID: <10097576.0110101450.4832c2c5@posting.google.com>

We have one database on codepage 932, one on 1252. They both need to have the same data (to be managed via middleware/3rd party applications). However, the 1252 codepage has diacritical characters like é, ñ, ú, etc.

Initial tests indicate that inserting these characters into our 932 database results in ?'s being displayed instead of the appropriate character, even if the client NLS_LANG is set to an appropriate character set.

From what I've been able to determine the JA16SJIS character set does not support these diacritical characters. Could someone confirm this for me?

What are the options for dealing with multiple languages across multiple instances using different character sets such as this?

Thanks for your help
Brett Received on Wed Oct 10 2001 - 17:50:16 CDT