Re: Problem with euro symbol

Yann PICHOT schreef:
> I use ODBC ANSI.
>
> I test ODBC Unicode but when i use it, SELECT statement don't return
> character column (CHAR and VARCHAR) and my database is not in Unicode0
>
> 2006/9/18, Stijn Vanroye < s(dot)vanroye(at)easytowork(dot)nl
> <mailto:s(dot)vanroye(at)easytowork(dot)nl>>:
>
> Yann PICHOT schreef:
> > Hi,
> >
> > I have a 8.1.4 database on windows with LATIN9 codepage .
> > In Java application (use JDBC driver postgresql-8.1-407.jdbc3.jar) on
> > Windows i write characters with euro symbole (ALT GR+E on my
> keyboard).
> > When i retrieve these characters data in my java application i
> see the
> > correct charater for euro symbol.
> > But when i retrieve these data with application use ODBC driver
> > ( 8.02.01.00 <http://8.02.01.00> <http://8.02.01.00>) the
> character that i see is not correct.
> >
> > How can i correct this problem ?
> >
> > --
> > Yann
>
> Do you use the ODBC ANSI or UNICODE driver? I'ts likely that your
> problem can be found in that corner.
>
> Regards,
>
> Stijn.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
>
>
> --
> Yann

Still I think the problem is to be found somewhere in that corner. I
myself use a dabase with UTF8 encoding in combination with the ODBC
UNICODE driver. I do howver add this to the connect settings of the
driver: SET CLIENT_ENCODING='LATIN1'

Maybe some of the charset/encoding experts can shed some more light on
this matter?

Regards, Stijn.