Hi Axton, I have done all these settings. I have imported the non unicode database to uncode supported database. When i am checking from SQL prompt , the data is displaying in proper format. After upgrade of ARS when i am entering data from the midtier and when search the records , the records are displaying in proper format.
When i am trying to search the records which i have imported on unicode supported then the records are not displaying in the proper format. My only problem is that imported data are not displaing in a proper way. Please give your inputs on this. Thanks & Regards Anil --- On Wed, 17/9/08, Axton <[EMAIL PROTECTED]> wrote: From: Axton <[EMAIL PROTECTED]> Subject: Re: Regarding Unicode database To: arslist@ARSLIST.ORG Date: Wednesday, 17 September, 2008, 7:16 PM You have to set up the UNIX environment properly. The install script will check for these values and either present or not present the option of installing as a Unicode capable arserver. I use the following values: LC_ALL=en_US.UTF-8 LANG=en_US.UTF-8 NLS_LANG=American_america.AL32UTF8 NLS_DATE_FORMAT=Mon DD YYYY HH24:MI:SS Axton Grams On Wed, Sep 17, 2008 at 9:05 AM, anil RAI <[EMAIL PROTECTED]> wrote: > ** > Hi Axton, > > Thanks for your response. > I have followed the same steps. The steps are 1. Export the ARSystem > 7.1 non unicode database. 2.I have installed the new database instance > with unicode support. 3. Import the non unicode database on newly > created instance of the database.4.Run the ARS 7.1 and connecting the > newly unicode database with upgrade option. > > But the problem is that when we are running the ARS 7.1 with upgrade > option it is nowhere asking to select explicitly unicode. > > Thanks & regards > Anil > > > > --- On Tue, 16/9/08, Axton <[EMAIL PROTECTED]> wrote: > > From: Axton <[EMAIL PROTECTED]> > Subject: Re: Regarding Unicode database > To: arslist@ARSLIST.ORG > Date: Tuesday, 16 September, 2008, 7:42 PM > > That list was a high level overview of the steps. Some caveats you > may run into: > - characters that do not translate properly from non-unicode to > unicode (7-bit ascii characters with ordinal value greater than 127). > These have to be addressed at the db level after the import into the > unicode db > - arserver configuration (environment variables for locale/lang/oracle > client, arserver configuration-ar.conf) > > Axton Grams > > On Tue, Sep 16, 2008 at 9:58 AM, Axton <[EMAIL PROTECTED]> wrote: >> You need to: >> >> - create a new db instance that uses the AL32UTF8 character set >> - import your non-unicode db into the new instance >> - you then need to upgrade/reinstall your arserver to a unicode version >> >> Axton Grams >> >> On Tue, Sep 16, 2008 at 2:26 AM, anil RAI <[EMAIL PROTECTED]> > wrote: >>> ** >>> Hi, >>> >>> If ORACLE database is non Unicode and ARS is connected with non >>> Unicode database. >>> >>> We have to upgrade the ARS as unicode then who is responsible for >>> upgrading database to unicode supported. >>> I mean BMC provides any document or white paper about how the DATABASE >>> is upgraded to unicode. >>> >>> >>> Thanks & Regards >>> Anil >>> ________________________________ >>> Did you know? You can CHAT without downloading messenger. Click here >>> __Platinum Sponsor: www.rmsportal.com > ARSlist: "Where the Answers > Are" >>> html___ >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ________________________________ > Unlimited freedom, unlimited storage. Get it now __Platinum Sponsor: > www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Connect with friends all over the world. Get Yahoo! India Messenger at http://in.messenger.yahoo.com/?wm=n/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"