Printing french accents

[c w]

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

[sybrandb]

"c w" <c.****@sympatico.ca> wrote in message news:<La*********************@news20.bellglobal.co m>...

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

NLS_LANG in the registry must be
FRENCH_FRANCE.WE8MSWIN1252.

The characterset of the database must be set to MSWIN1252.
If the characterset is incorrect, you should have lost all accents.
Could you check from the server they are actually there?

Sybrand Bakker
Senior Oracle DBA

[Tony]

"c w" <c.****@sympatico.ca> wrote in message news:<La*********************@news20.bellglobal.co m>...

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

French accents? How about using
TRANSLATE(REPLACE(text,'TH','Z'),'H','''')

As in:

SQL> SELECT TRANSLATE(REPLACE('THE CAT IS IN THE
HOUSE','TH','Z'),'H','''') FROM DUAL;

ZE CAT IS IN ZE 'OUSE

Sorry, couldn't resist it ;-)