fun with character sets
Date: Wed, 10 May 2017 13:05:40 +0000
Message-ID: <37a8cee7f9ff4a399825fc57ff3367f3_at_wpvl1dag04.hcrec.com>
I've created a new dev environment for one of our systems.
The old system used we8iso8859p1 / al16utf16 for the character set and NCHAR character set.
The new system uses AL32UTF8 / al16utf16 for the character set and NCHAR character set
Both DBs are version 11.2.0.4 on Solaris 10
The application is written in Forms and the same app tier (web logic, forms server, etc) is used to access both databases.
On the new system, the login screen is returning ORA-12713
oerr ora 12713
12713, 00000, "Character data loss in NCHAR/CHAR conversion"
// *Cause: When character set conversion happens between CHAR and NCHAR
// either implicitly or explicitly, some characters are lost
// due to no mapping characters in the destination character set.
// *Action: Make sure all the characters can be mapped to destination
//
I've checked the application tables and NONE of them have any columns of type NCHAR or NVARCHAR or NCLOB. The NLS_NCHAR_CONV_EXP parameter is set to FALSE on both systems.
I can't figure out why this error is being thrown. I can't even figure out why the app is appearing to try to convert from the normal character set to the nchar character set (or vice versa) when none of the application tables use those data types.
Anyone have any helpful thoughts?
**** This communication may contain privileged and/or confidential information. If you are not the intended recipient, you are hereby notified that disclosing, copying, or distributing of the contents is strictly prohibited. If you have received this message in error, please contact the sender immediately and destroy any copies of this document. ****
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 10 2017 - 15:05:40 CEST