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
> 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
> > 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.
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
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
In response to
pgsql-odbc by date
|Next:||From: Lemaire Vincent||Date: 2006-09-18 21:14:49|
|Subject: Error for insert large object|
|Previous:||From: Yann PICHOT||Date: 2006-09-18 14:23:09|
|Subject: Re: Problem with euro symbol|