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 using a localized version of windows and entered/pasted or otherwise inserted localized data into your db? reply-> we have czech/polish customers using our application using a localized version of windows, they might have been adding localized data into the db Have you used any non 7-bit ASCII characters in any of your form or workflow definitions (copied any data from word into the notes or change history of any workflow definitions)? reply-> no What version of ARServer was initially installed when the system was built? reply-> it was ARS 6.0 What versions of the Remedy User Tool do/have people used (earliest version)? reply-> it was 6.0 Thanks in advance for your help Best Regards, Antonio Monizza On Thu, Jul 1, 2010 at 6:59 PM, Axton <axton.gr...@gmail.com> wrote: > ** > 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 > entered/pasted or otherwise inserted localized data into your db? > > Have you used any non 7-bit ASCII characters in any of your form or > workflow definitions (copied any data from word into the notes or change > history of any workflow definitions)? > > What version of ARServer was initially installed when the system was built? > What versions of the Remedy User Tool do/have people used (earliest > version)? > > > All of the non-Unicode to Unicode upgrades I've done have been from a 6.x o > 7.x Remedy server (6.0.1 to 7.0.1 and 6.3 to 7.5), so I can't speak as to > how one should upgrade with the versions you are working with. > > Axton Grams > > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as a > spokesperson, liaison or public relations representative for BMC Software, > Inc. > > On Tue, Jun 29, 2010 at 6:35 PM, Antonio Monizza <antomoni...@gmail.com>wrote: > >> ** 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 server in >> Unicode mode, >> then we will point app server to a new db machine with Oracle 10, >> eventually we want to upgrade to ARS 7.5. >> >> Currently we are focusing on the non Unicode to Unicode upgrade step, so >> we are looking for any valuable advise on the topic. >> At BMC support they keep on saying that a brand new ARS installation in >> Unicode mode is needed (i.e. no upgrade), >> and then def+data must be imported at ARS level >> >> Has anyone of you ever tried to upgrade ARS 7.1.0 from non Unicode to >> Unicode mode ‘simply’ changing parameters >> and environment variables (LANG and LC_ALL) and locale settings on the ARS >> application server, >> acting directly on ar.conf and arsystem files, and then doing a >> stop/restart of ars server? >> >> Should a new installation be inevitable, we really want to avoid using >> migrator or arimport for data migration >> (too many forms, too many data…), and use oracle export/import instead of >> whole arschema: >> has anyone of you ever tried this option? >> >> Any advise and suggestion on this topic is very welcome! >> >> Thanks in advance >> >> Best Regards, >> Antonio Monizza >> >> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"