470,591 Members | 2,202 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

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
Jul 19 '05 #1
2 6054
"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
"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.

Similar topics

reply views Thread by Wim Roffal | last post: by
2 posts views Thread by yearTiger2002 | last post: by
reply views Thread by Chris Leffer | last post: by
3 posts views Thread by Alt255 | last post: by
3 posts views Thread by bss | last post: by
2 posts views Thread by c w | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.