BUG #1974: UTF-8 french postmaster messages corrupted
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
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/
Hello Peter,
On the 8.0.4 db cluster, I get the following:
template1=# SHOW lc_ctype;
lc_ctype
-------------
fr_FR.UTF-8
(1 ligne)
Temps : 1,041 ms
template1=# SHOW server_encoding;
server_encoding
-----------------
UNICODE
(1 ligne)
Temps : 0,562 ms
On the 8.0.2 db cluster, I get:
template1=# SHOW lc_ctype;
lc_ctype
-------------
fr_FR.UTF-8
(1 ligne)
Temps : 76,591 ms
template1=#
template1=# SHOW server_encoding;
server_encoding
-----------------
UNICODE
(1 ligne)
Temps : 0,621 ms
Any clue ?
Show quoted text
-----Message d'origine-----
De: Peter Eisentraut [mailto:peter_e@gmx.net]
Date: mardi 18 octobre 2005 16:40
À: REISS Thomas DSIC DESP
Cc: pgsql-bugs@postgresql.org
Objet: Re: [BUGS] BUG #1974: UTF-8 french postmaster messages
corruptedAm Dienstag, 18. Oktober 2005 15:00 schrieb Thomas Reiss:
[postgres@bu04 postgres]$ pg_ctl stop
en attente de l'arrÃfªt du postmaster....TRACE: arrÃfªten cours des
traces
fait
postmaster arrÃfªtÃf©This probably means that the LC_CTYPE setting on your server
does not match
the database encoding. Please send us the output ofSHOW lc_ctype;
SHOW server_encoding;--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Import Notes
Resolved by subject fallback