Our is set to BYTE. These parameters can be configured at the oracle instance level in either the spfile or init.ora, depending on your configuration, if you need them to stick. I will say hi :)
Axton Grams On Fri, Aug 15, 2008 at 11:03 AM, Rabi Tripathi <[EMAIL PROTECTED]> wrote: > Thanks Axon. I will keep these in mind. We'll be using > the same settings. > > There is some confusion about the following oracle > setting: > NLS_LENGTH_SEMANTICS > > For unicode (oracle) databases, 7.0.1 install guide > says it should be set to CHAR, 7.1 install guide says > it should be set to BYTE. > > I'm wondering if one of them is a typo or each one is > correct for each version. > > We also had issues changing this setting in oracle. We > tried "ALTER.." to change it, but didn't seem to stick > even after restarting oracle. We also tested setting > this as a shell variable and doing sqlplus, but our > session doesn't pick it up. However, I believe this is > a server side setting. > > <personal message tunnel> > Please say hi to aiping t. and mike f. > </personal message tunnel> > > --- Axton <[EMAIL PROTECTED]> wrote: > >> The two env vars that matter on the remedy server >> are: >> LC_ALL=en_US.UTF-8 >> LANG=en_US.UTF-8 >> >> On the oracle side, we use the AL32UTF8 as the >> character set with all >> the NLS stuff set up as America.American. >> >> Axton Grams >> >> On Fri, Aug 15, 2008 at 10:30 AM, Rabi Tripathi >> <[EMAIL PROTECTED]> wrote: >> > Hi all, >> > After a lot of issues trying to add language packs >> to >> > existing ARS 7.1 p2 install, we're starting from >> > scratch and doing a new install (Solaris , Oracle) >> to >> > included most of the language packs available in >> ARS. >> > >> > If anybody has gone through this process and can >> share >> > any lessons learned, caveats, I would appreciate. >> > >> > When it comes to internationalization, >> localization, >> > I've experienced that because all the settings >> have to >> > be just right at multiple levels (OS, database, >> ARS, >> > client) it's a challenge to get it to work. >> > >> > So I'm trying to pick anybody's brain to >> supplement >> > reading through the install guides, release notes >> and >> > what not. >> > >> > Thanks in advance. >> > >> > Oracle 10g Release 10.2.0.4.0 - 64bit >> > SunOS 5.10 (separate box for ars and db) >> > Installing ARS 7.1 p2 >> > >> > >> > >> > >> > >> > >> > >> > _______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org >> > Platinum Sponsor: www.rmsportal.com ARSlist: >> "Where the Answers Are" >> > >> >> > _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where >> the Answers Are" >> > > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
