Re: Printing french accents
From: Tony <andrewst_at_onetel.net.uk>
Date: 18 Jun 2004 07:04:47 -0700
Message-ID: <c0e3f26e.0406180604.5a6101de_at_posting.google.com>
Date: 18 Jun 2004 07:04:47 -0700
Message-ID: <c0e3f26e.0406180604.5a6101de_at_posting.google.com>
"c w" <c.wyke_at_sympatico.ca> wrote in message news:<LavAc.50913$7H1.1725735_at_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.
>
>
> 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 ;-) Received on Fri Jun 18 2004 - 16:04:47 CEST