Re: Accents for TEXT - Mailing list pgsql-jdbc

From tony
Subject Re: Accents for TEXT
Date
Msg-id 1017316791.22963.20.camel@vaio
Whole thread Raw
In response to Re: Accents for TEXT  ("Elisabeth Julg" <elisabeth.julg@steria.com>)
Responses Re: Accents for TEXT
List pgsql-jdbc
On Thu, 2002-03-28 at 12:50, Elisabeth Julg wrote:

> I have try to compile just with --enable-multibyte
> (without --enable-locale). But I can't start postmaster (cause LC_LOCALE).
>
> With --enable-multibyte without --enable-locale,
> With a database encoded ISO8859-1 (or ISO8859-9) and url
> ...?charset=ISO8859-1 (or ISO8859-9), I have always the same problem (with
> the old database or new).
> If LC_LOCALE (and co). are positionned at fr_FR@euro or not, the result is
> the same : accents are transfomed in '?' character.
> Note : It works well with VARCHAR, but not with TEXT field. For Windows
> system, I have no problem, but in production I need use Mandrake 8.1.
>
> Variables LC_LOCALE (and co) are importants ?

Have you tried the rpms? I haven't tried compiling since the excellent
people on this list who make rpms included java and multibyte.

So I just rpm -Uvh postgresql*

And it works. I am having problems with ' in queries wich look for
"l'art" etc. But accents work just fine in java, psql, perl you name it
they work!

> Sincères salutations,

How formal... sur les listes cordialement c'est mieux!

> (PS: Je serai en congès demain et la semaine prochaine).

Il y en a qui ont de la chance...

Cheers

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


pgsql-jdbc by date:

Previous
From: "Elisabeth Julg"
Date:
Subject: Re: Accents for TEXT
Next
From:
Date:
Subject: Re: Primary Key