Re: UTL_FILE to handle French characters

On 25 May 2004 12:43:05 -0700, xiangminyao_at_yahoo.com (Max) wrote:

>Hello everyone,
>
> I am trying to use UTL_FILE in one of my PL/SQL routines and
>everything
>works perfectly except for one small thing : I am loosing all my
>accents
>in French and any other languages using accents. E.g. ÃToronto in
>database, I got Ã\203Toronto in the data file.
>
> Anybody has any idea how to make this work? I have tried seting my
>NLS_LANG to a different value to make them appear but it won't work.
>COuld the problem be with UTL_FILE itself not handling 8-bits
>characters?
>
> Any help is appreciated.
>
>Thanks,
>Max

You will probably only get help if you specify *exactly* what you are doing, including your NLS_LANG setting *and* the characterset of your O/S, *and* your version, *and* your O/S, as is always requested to everyone.
No one here can pull out a crystall ball and see what you are doing exactly

--
Sybrand Bakker, Senior Oracle DBA