Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: French Characters
We had a similar problem. Here's what I can suggest.
At run-time (access-time), try to set the variable TNS_LANG to
'FRENCH_AMERICA.WE8DEC'. The way you set it depends on your O/S, but it
should be done the same way you set the ORACLE_SID variable. Also, make
sure the initialization parm NLS_LANGUAGE in the oinit file is set the
same.
Hope this'll help.
(this is odd to read nearby city names into this newsgroup...)
-- Michel Gauthier qgmi1_at_qbc.clic.net Produits Forestiers Donohue Inc. The ideas expressed/language used reflect those of the author, Not necessarly those of Donohue Inc. omar <omar_at_quadrasys.com> wrote in article <34A71C72.AD4CF1F_at_quadrasys.com>...Received on Tue Dec 30 1997 - 00:00:00 CST
> Hi,
>
> We are using a trial version of Oracle; we deal with french characters
> in our database.
> When we created the database through "cr_databaseName.sql" we used this
> value for this
> parameter:
> character set "we8dec"
>
> After that we ran the database and entered these words which contain
> some french
> characters
> Rivière-du-Loup, Sept-Îles, Montréal, Québec
> when we tried to retrieve these word from the database we got this:
> Rivihre-du-Loup, Sept-Nles, Montrial ,Quibec
>
> What do we have to do to be able to enter french words and get back the
> same french
> words from the database?
>
>
>