IT Forums - French accents

c w

06-17-2004, 09:42 PM

Can anyone point me in the right direction?
Using Oracle 9i, Pro*C and Excel. I am trying to print french accents from
the Oracle DB
using Pro*C to extract the necessary info and sent the result to Excel but
at the moment
I cannot get the accents to show in Excel. The NLS_LANG is America.
Any help would be appreciated. Thanks.

Colin

G Dahler

06-23-2004, 08:50 AM

"c w" <c.wyke@sympatico.ca> a écrit dans le message de
news:vgvAc.50918$7H1.1726449@news20.bellglobal.com... Can anyone point me in the right direction? Using Oracle 9i, Pro*C and Excel. I am trying to print french accents from the Oracle DB using Pro*C to extract the necessary info and sent the result to Excel but at the moment I cannot get the accents to show in Excel. The NLS_LANG is America. Any help would be appreciated. Thanks.
Can you see the accented characters from SQL*Plus on the windows client ?

Try AMERICAN_AMERICA.WE8ISO8859P1 as NLS_LANG.

Of course, this assumes that your database char set is ISO8859P1

If your DB is in US7ASCII, tough luck, no accents !

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service