Re: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-07-23 Thread Antonio Monizza
Hi Axton, sorry for my late reply but I've been out of office during the last 2 weeks. Do you have any localized data currently in the database? Particularly CJK data or any other type of multi-byte or localized data? reply- we do not have CJK data Have clients connected to your remedy server

Re: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-07-05 Thread Misi Mladoniczky
Hi, If you use ARAdmin/DeveloperPlus to move the detinitions, you can use RRR|Chive to move the data. RRR|Chive uses the API, and will automatically convert the data to the correct character set. Download and configure at: https://www.rrr.se/cgi/rrrchive/main This requires that you have both

Re: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-07-01 Thread Fons Bruins
Hi Conny, Will this hack also work on a MS SQL 2005 DB ? We are planning a similar Unicode conversion from ARS 7.0.1 to ARS 7.5 Could you share the additional information to me as well ? Thank you for your help. Regards, Fons

AW: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-07-01 Thread Conny Martin
Fons, sorry, but my hack has been proved to work on unix. I've never done this on a windows box with MSSQL. The installer for unix-systems is a simple shell script where one can see what's going on behind the scenes. The installer for windows is more like a black box. Furthermore the database

Re: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-07-01 Thread Axton
A couple of questions that will determine the complexity of the process: Do you have any localized data currently in the database? Particularly CJK data or any other type of multi-byte or localized data? Have clients connected to your remedy server using a localized version of windows and

Re: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-06-30 Thread Antonio Monizza
Thanks a lot Conny for your contribution, if I understand well, you're suggesting to 'cheat' the installer making it believe to do an upgrade from 6 to 7. Can you provide some more details on how to do that? Isn't it necessary anymore to 'prepare' the server with environment variables and

ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-06-29 Thread Antonio Monizza
Hello listers, we have a custom application, with ARS 7.1.0 server on AIX machine, installed in NON Unicode mode and pointing to AIX db server with Oracle 9.2, characterset UTF8. So database is already Unicode enabled, ARS is not. We are planning to do a major upgrade: we need to have our ARS

AW: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines

2010-06-29 Thread Conny Martin
Antonio, Simply changing parameters, locale settings etc. won't work. The reason is explained in document BMC Remedy Action Request System 7.1.00 Installing on page 162. The only supported way to upgrade to Unicode is from 6.3 to 7.x But you can do a little hack. In short: 1. UPDATE .control