RE: Installing an app on a French configured server

Stephane

How do we make the character set French?(WE8ISO8859P15) on our test database?
(Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?).

Is this something that has to be done when installing Oracle, or when creating the database(SID)? If so, how do we specify that we want this character set?

Or can we change an existing installation or database?

Any assistance appreciated

John Dunn

> -----Original Message-----
> From: Stephane Faroult [SMTP:sfaroult_at_oriole.com]
> Sent: 16 May 2002 21:24
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Installing an app on a French configured server
>
> Barry Deevey wrote:
> >
> > Hello all,
> >
> > There is a requirement to install our application at a site that will
> have
> > both Oracle (8.1.7) & Unix (AIX 5.1) configured in the French language.
> >
> > Can anybody please advise me of anything that I need to be aware of in
> > relation to the differences between an English & French configuration??
> >
> > Any help is greatly appreciated.
> >
> > Best Regards,
> >
> > Barry.
>
> o Character sets (likely to be WE8ISO8859P15 in France - accents plus
> euro character)
> o Beware of tests on dates, especially if the day matters
> o Subtle but annoying, numbers. The default decimal character is a comma
> in France, and you sometimes (although rarely) meet a dot as separator
> for thousands. Can be a big problem when loading data from external
> sources - or generating files to be loaded say into Excel.
>
> And Oracle error messages in French are totally ununderstandable, even
> to the French.
>
> HTH,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriole.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).