Re: Accents for TEXT

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