I would suggest doing a new install on unicode and migrate application and data 
with the API (RRR|Chive for instance). Doing this on the DB level can result in 
strange things if you have ANY ascii character greater than 127 in for examples 
your labels.

Also some data in unicode will not fit in the max length of the fields, which 
can be fixed by increasing the field length as needed. The places to do this 
will not be found if you do this on the DB level.

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
April 11, 2018 1:27 PM, "Theo Fondse"  wrote: 
        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: 

        · Oracle Character Set Migration: 

        · Change Oracle 12c database character set to WE8MSWIN1252 from 
AL32UTF8 without recreating the DB: 

        · Oracle Database Migration Assistant for Unicode (DMU) in Oracle 
Database 12c Release 1 (12.1): 

        Best Regards, 

        Theo Fondse 

        From: ARSList [mailto:arslist-boun...@arslist.org 
(mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of LJ LongWing
Sent: Wednesday, 4 April, 2018 07:54 PM
To: ARSList 
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  wrote:  
        Yep … For ARS 9 I would have expected NLS_CHARACTERSET to be AL32UTF8 
(The Unicode value) 
        From: ARSList [mailto:arslist-boun...@arslist.org 
(mailto:arslist-boun...@arslist.org)] On Behalf Of Thomas Miskiewicz
Sent: Wednesday, April 4, 2018 6:57 AM
To: LJ LongWing 
Cc: ARSList 
Subject: [E] Re: Special characters in ARS 
        On Apr 4, 2018, at 1:56 PM, LJ LongWing  wrote: 
        Character set at the db? 
        On April 4, 2018 4:47:12 AM Thomas Miskiewicz  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@arslist.org (mailto:ARSList%40arslist.org)
ARSList mailing list
ARSList@arslist.org (mailto:ARSList@arslist.org)
ARSList mailing list

Reply via email to