You can do it at anytime if the character set you are changing to is a supset of the current set. If it is not, you will have to export and import you database for the changes to take place.
HTH, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 7:28 AM > 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:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
