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

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 Sat Jul 06 2002 - 05:16:53 CDT