Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #1974: UTF-8 french postmaster messages corrupted

BUG #1974: UTF-8 french postmaster messages corrupted

From
"Thomas Reiss"
Date:
The following bug has been logged online:

Bug reference:      1974
Logged by:          Thomas Reiss
Email address:      thomas.reiss@interieur.gouv.fr
PostgreSQL version: 8.0.4
Operating system:   Linux Fedora Core 1
Description:        UTF-8 french postmaster messages corrupted
Details:

Hello,

The french messages lost their accents in the latest stable release.
When in 8.0.4 with $LANG=fr_FR.UTF-8, I get:
[postgres@bu04 postgres]$ echo $LANG
fr_FR.UTF-8
[postgres@bu04 postgres]$ pg_ctl stop
en attente de l'arrêt du postmaster....TRACE:  arrêt en cours des
traces
 fait
postmaster arrêté


When in 8.0.2, on the same server, with $LANG=fr_FR.UTF-8, I get the
following, which is correct:
[postgres@host postgres]$ echo $LANG
fr_FR.UTF-8
[postgres@host postgres]$ pg_ctl stop
en attente de l'arrêt du postmaster.... fait
postmaster arrêté

I did this tests in the same session, I just switch from an environnement to
another by resetting the $PATH and $PGDATA environnement variables.


Thanks in advance.
Thomas

Re: BUG #1974: UTF-8 french postmaster messages corrupted

From
Peter Eisentraut
Date:
Am Dienstag, 18. Oktober 2005 15:00 schrieb Thomas Reiss:
> [postgres@bu04 postgres]$ pg_ctl stop
> en attente de l'arrêt du postmaster....TRACE:  arrêt en cours des
> traces
>  fait
> postmaster arrêté

This probably means that the LC_CTYPE setting on your server does not match
the database encoding.  Please send us the output of

SHOW lc_ctype;
SHOW server_encoding;

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: BUG #1974: UTF-8 french postmaster messages corrupted

From
REISS Thomas DSIC DESP
Date:
Hello Peter,


On the 8.0.4 db cluster, I get the following:
template1=3D# SHOW lc_ctype;
  lc_ctype
-------------
 fr_FR.UTF-8
(1 ligne)

Temps : 1,041 ms
template1=3D# SHOW server_encoding;
 server_encoding
-----------------
 UNICODE
(1 ligne)

Temps : 0,562 ms

On the 8.0.2 db cluster, I get:
template1=3D# SHOW lc_ctype;
  lc_ctype
-------------
 fr_FR.UTF-8
(1 ligne)

Temps : 76,591 ms
template1=3D#
template1=3D# SHOW server_encoding;
 server_encoding
-----------------
 UNICODE
(1 ligne)

Temps : 0,621 ms


Any clue ?


> -----Message d'origine-----
> De: Peter Eisentraut [mailto:peter_e@gmx.net]
> Date: mardi 18 octobre 2005 16:40
> =C0: REISS Thomas DSIC DESP
> Cc: pgsql-bugs@postgresql.org
> Objet: Re: [BUGS] BUG #1974: UTF-8 french postmaster messages=20
> corrupted
>=20
>=20
> Am Dienstag, 18. Oktober 2005 15:00 schrieb Thomas Reiss:
> > [postgres@bu04 postgres]$ pg_ctl stop
> > en attente de l'arr=C3f=C2=AAt du postmaster....TRACE:  arr=C3f=C2=AAt=
=20
> en cours des
> > traces
> >  fait
> > postmaster arr=C3f=C2=AAt=C3f=C2=A9
>=20
> This probably means that the LC_CTYPE setting on your server=20
> does not match=20
> the database encoding.  Please send us the output of
>=20
> SHOW lc_ctype;
> SHOW server_encoding;
>=20
> --=20
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>=20