Re: Developing against English version of Oracle, running against French version

Dear Yang,
Thanks for the info.

James

"Yang" <yg.yang_at_wanadoo.fr> wrote in message news:<ag6h16$3gp$1_at_wanadoo.fr>...
> We work with English version of Oracle at Paris and our clients are french
> company.
>
> You should take care about the characterset. I suggest you WE8ISO8859P1.
>
> And when you work againt your database (exp/imp, insert, delete, select
> etc), you should consider carefully about NLS settings, especially NLS_LANG
> (at Unix server, see env variables; at Windows PC, see register). For
> example :
>
> Againt the same database (with english and french data stored), I use
> NLS_LANG=american_america.WE8ISO8859P1 for english display and
> NLS_LANG=french_france.WE8ISO8859P1 for french display.
>
> hth
>
> Yang
> Senior Oracle DBA
>
>
> "James Lavery" <james_at_microsec.co.uk> wrote in message
> news:b966b3b3.0207050147.13e2c3e8_at_posting.google.com...
> > We're about to start a development project for a French customer, and
> > will be developing against an English version of Oracle.
> >
> > Naturally, the customer will be running a French version.
> >
> > Are we going to have problems with this scenario?
> >
> > I assume that schema definition etc. are language-independent (i.e.
> > always in English - being English-centric). What about character sets
> > etc.
> >
> > If necessary, we can install French and develop against it.
> >
> > Thanks,
> >
> > James Lavery
> > MicroSec Ltd
Received on Mon Jul 08 2002 - 02:46:35 CDT