Problem with euro symbol

------=_Part_229174_16390837.1158330044066
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_229174_16390837.1158330044066
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

How can i correct this problem ?

--
Yann

------=_Part_229174_16390837.1158330044066--

Re: Problem with euro symbol

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

Re: Problem with euro symbol

------=_Part_274766_32645029.1158589389949
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_274766_32645029.1158589389949
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Problem with euro symbol

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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Problem with euro symbol

------=_Part_938_24555466.1159255700700
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

2006/9/25, Johann Zuschlag :
>
>
> 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

------=_Part_938_24555466.1159255700700
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Re: Problem with euro symbol

Yann PICHOT schrieb:
>
>
> 2006/9/25, Johann Zuschlag > >:
>
>
> 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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Problem with euro symbol

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match