By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

Printing french accents

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Jul 19 '05 #2

P: n/a
"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 ;-)
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.