Re: [E] Re: Special characters in ARS
Hi, 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 2011) 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 (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: http://support.etouch.net/cm/wiki/?id=43321 (http://support.etouch.net/cm/wiki/?id=43321) · Oracle Character Set Migration: https://docs.oracle.com/cd/B10500_01/server.920/a96529/ch10.htm (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 (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 (https://oracle-base.com/articles/12c/database-migration-assistant-for-unicode-dmu-12cr1) 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? Thomas -- ARSList mailing list ARSList@arslist.org (mailto:ARSList%40arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k=Yj3CmHHm6F9uWhgJeWLmkHV-zdqz_nDsL-v_SsGICdg=UdcwcFOjXTJFfA5-XKryB0xjoRujPbFTuowgEggjRVI=) -- ARSList mailing list ARSList@arslist.org (mailto:ARSList@arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://mailman.rrr.se/cgi/listinfo/arslist) -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
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-boun...@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 <mailto:arslist@arslist.org> > 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 <lj.longw...@gmail.com <mailto:lj.longw...@gmail.com> > Cc: ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > Subject: [E] Re: Special characters in ARS On Apr 4, 2018, at 1:56 PM, LJ LongWing <lj.longw...@gmail.com <mailto:lj.longw...@gmail.com> > wrote: Character set at the db? On April 4, 2018 4:47:12 AM Thomas Miskiewicz <tmisk...@gmail.com <mailto:tmisk...@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? Thomas -- ARSList mailing list ARSList@arslist.org <mailto:ARSList%40arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k=Yj3CmHHm6F9uWhgJeWLmkHV-zdqz_nDsL-v_SsGICdg=UdcwcFOjXTJFfA5-XKryB0xjoRujPbFTuowgEggjRVI=> -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
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-boun...@arslist.org] *On Behalf Of *Thomas > Miskiewicz > *Sent:* Wednesday, April 4, 2018 6:57 AM > *To:* LJ LongWing <lj.longw...@gmail.com> > *Cc:* ARSList <arslist@arslist.org> > *Subject:* [E] Re: Special characters in ARS > > > > [image: 2E266723.gif] > > > > > > On Apr 4, 2018, at 1:56 PM, LJ LongWing <lj.longw...@gmail.com> wrote: > > > > Character set at the db? > > > > On April 4, 2018 4:47:12 AM Thomas Miskiewicz <tmisk...@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? > > > > > > Thomas > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k=Yj3CmHHm6F9uWhgJeWLmkHV-zdqz_nDsL-v_SsGICdg=UdcwcFOjXTJFfA5-XKryB0xjoRujPbFTuowgEggjRVI=> > > > > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: [E] Re: Special characters in ARS
Yep … For ARS 9 I would have expected NLS_CHARACTERSET to be AL32UTF8 (The Unicode value) From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Thomas Miskiewicz Sent: Wednesday, April 4, 2018 6:57 AM To: LJ LongWing <lj.longw...@gmail.com> Cc: ARSList <arslist@arslist.org> Subject: [E] Re: Special characters in ARS [2E266723.gif] On Apr 4, 2018, at 1:56 PM, LJ LongWing <lj.longw...@gmail.com<mailto:lj.longw...@gmail.com>> wrote: Character set at the db? On April 4, 2018 4:47:12 AM Thomas Miskiewicz <tmisk...@gmail.com<mailto:tmisk...@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? Thomas -- ARSList mailing list ARSList@arslist.org<mailto:ARSList%40arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwMFaQ=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k=Yj3CmHHm6F9uWhgJeWLmkHV-zdqz_nDsL-v_SsGICdg=UdcwcFOjXTJFfA5-XKryB0xjoRujPbFTuowgEggjRVI=> -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
