Skip site navigation (1) Skip section navigation (2)

Re: Problem with euro symbol

From: Stijn Vanroye <s(dot)vanroye(at)easytowork(dot)nl>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with euro symbol
Date: 2006-09-18 15:24:50
Message-ID: eeme0j$cs3$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

In response to

pgsql-odbc by date

Next:From: Lemaire VincentDate: 2006-09-18 21:14:49
Subject: Error for insert large object
Previous:From: Yann PICHOTDate: 2006-09-18 14:23:09
Subject: Re: Problem with euro symbol

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group