Re: French accents

From: G Dahler <yellow-shark_at_spamex.com>
Date: Wed, 23 Jun 2004 12:50:53 -0400
Message-ID: <cyiCc.29594$Nz.1316144_at_news20.bellglobal.com>

"c w" <c.wyke_at_sympatico.ca> a �crit dans le message de news:vgvAc.50918$7H1.1726449_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.
>
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 ! Received on Wed Jun 23 2004 - 18:50:53 CEST

This message: [ Message body ]
Next message: Romeo Olympia: "Re: STARTUP Instance with (s)pfile -> invalid character"
Previous message: jhking: "Re: Free database tools announcements - invitation to discussion"
In reply to: c w: "French accents"
In reply to c w: "Help"
Next in thread: Romeo Olympia: "Re: STARTUP Instance with (s)pfile -> invalid character"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message