LJ is correct, you are attempting to enter a character with a UNICODE code into a NON-UNICODE DB.
Your NLS_CHARACTERSET value indicates you have a NON-UNICODE DB.
You will need to convert your DB to UNICODE to sort out your issue.
Oracle 12c has a conversion utility (DMU) to convert a DB to UNICODE.
We had to use DMU recently to convert a DB to UNICODE.
BE WARNED: This process takes very long and you need a lot of free space available to do this (depending on the size of your DB).
Please also remember to set the LANG variable correctly on your Remedy ARS server if that runs on a Solaris or Unix OS afterwards, to ensure Remedy talks in UNICODE to the DB.
Alternatively, stick to NON-UNICODE and forget about adding “very special” characters to your data….
The below links might be helpful:
· Oracle How to check character set in Oracle: http://support.etouch.net/cm/wiki/?id=43321
· Oracle Character Set Migration: https://docs.oracle.com/cd/B10500_01/server.920/a96529/ch10.htm
· Change Oracle 12c database character set to WE8MSWIN1252 from AL32UTF8 without recreating the DB: https://stackoverflow.com/questions/34763891/change-oracle-12c-database-characterset-to-we8mswin1252-from-al32utf8-without-re
· Oracle Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1): https://oracle-base.com/articles/12c/database-migration-assistant-for-unicode-dmu-12cr1
From: ARSList [mailto:firstname.lastname@example.org] On Behalf Of LJ LongWing
I'm not a unicode expert, but I believe what you might be dealing with is that the characterset you are using might not be able to properly store the character you are asking for.
On Wed, Apr 4, 2018 at 11:18 AM, Fred Grooms via ARSList <email@example.com> wrote: