Re: UTL_FILE to handle French characters

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<osb7b05ors9i6d3s900ujdvanbhr84nveq_at_4ax.com>...
> 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

The purpose of my program is extract data from Infranet database (Oracle 8.1.7) by using utl_file in PL/SQL script. The database is running on SunOS. The character set of the database is UTF8. I have the following settings in my profile

NLS_LANG=AMERICAN_AMERICA.UTF8
LANG=C
LC_CTYPE=iso_8859_1
stty cs8 -istrip -parenb

The data file should be fixed length. Because French character always occupies two bytes, the columns after the French character is moved one character right.

Thanks,
Max Received on Tue May 25 2004 - 21:32:20 CDT