Thread: Problem with euro symbol

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) the character that i see is not correct.

How can i correct this problem ?

--
Yann

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>) 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.

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




--
Yann

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.vanroye@easytowork.nl
> <mailto:s.vanroye@easytowork.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.

Yann PICHOT schrieb:
> 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>) the character that i see is not correct.
>
> How can i correct this problem ?
>
> --
> Yann

Hi,

maybe you try to use Latin15, since the euro symbol is not part of Latin9.

Regards,

Johann

Hi,

LATIN15  don't exist, euro symbol is port of LATIN9.
See documentation of version 8.1 int the chapter 21.2.1

Regards,
--
Yann

Yann PICHOT schrieb:
>
>
> 2006/9/25, Johann Zuschlag <zuschlag2@online.de
> <mailto:zuschlag2@online.de>>:
>
>
>     Hi,
>
>     maybe you try to use Latin15, since the euro symbol is not part of
>     Latin9.
>
>     Regards,
>
>     Johann
>
>
> Hi,
>
> LATIN15  don't exist, euro symbol is port of LATIN9.
> See documentation of version 8.1 int the chapter 21.2.1
>
> Regards,
> --
> Yann
Hi,

I'm sorry, you are right. I mixed that with ISO8859-1.

When I conducted tests with a LATIN9 (ISO8859-15 to make it more clear
;-) ) database I didn't face any problems. I especially tested the
euro-symbol.

LATIN9 database + ODBC-unicode driver
writing and retrieving the euro-symbol worked.

Which windows version are you using? I tested XP and ME with the unicode
driver. There ANSI-driver is not to be used any more, except for BDE, if
I recall correctly.

Regards,

Johann

Johann Zuschlag schreef:
  > Which windows version are you using? I tested XP and ME with the
unicode
> driver. There ANSI-driver is not to be used any more, except for BDE, if
> I recall correctly.
And even for BDE you can do without the ANSI. I use the ADO component
set in combination with the unicode driver. The only extra I did was add
"SET CLIENT_ENCODING='LATIN1'" in the connection settings part of the
connection string. Before that we also had some symbols not working.

Regards,

Stijn Vanroye
www.easytowork.nl
www.xillion.nl