[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

RE: [E] Re: Special characters in ARS

Hi Thomas,


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



Best Regards,


Theo Fondse


From: ARSList [mailto:arslist-bounces@arslist.org] On Behalf Of LJ LongWing
Sent: Wednesday, 4 April, 2018 07:54 PM
To: ARSList <arslist@arslist.org>
Subject: Re: [E] Re: Special characters in ARS


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 <arslist@arslist.org> wrote:

Yep …  For ARS 9  I would have expected NLS_CHARACTERSET to be AL32UTF8  (The Unicode value)


From: ARSList [mailto:arslist-bounces@arslist.org] On Behalf Of Thomas Miskiewicz
Sent: Wednesday, April 4, 2018 6:57 AM
To: LJ LongWing <lj.longwing@gmail.com>
Cc: ARSList <arslist@arslist.org>
Subject: [E] Re: Special characters in ARS





On Apr 4, 2018, at 1:56 PM, LJ LongWing <lj.longwing@gmail.com> wrote:


Character set at the db?


On April 4, 2018 4:47:12 AM Thomas Miskiewicz <tmiskiew@gmail.com> wrote:

Hi there,


We’re on ARS 9.1.03 with Oracle 12.


When I enter Avșar into the a character field I get Av¿ar after saving. 


Any idea how to fix this?




ARSList mailing list



ARSList mailing list