From: | Bob Lunney <bobl(at)aweber(dot)com> |
---|---|
To: | gesteam_l4d(at)gesteam(dot)fr |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG 9.4.4 issue on French Windows 32 bits |
Date: | 2015-07-08 17:10:38 |
Message-ID: | B5D0B852-3CD0-4DAD-8554-46A8D1E0DF89@aweber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thierry,
Please post the output of
$ psql -l
for the database in question for both the 32-bit and 64-bit servers. That will show what encoding was specified when the databases where created.
Also, post the output of
$ psql <dbname here> <login> -c “show client_encoding”
$ psql <dbname here> <login> -c "show all" | grep lc_
s'il vous plaît. Also check if any code is setting client_encoding or any of the lc_* options on the fly.
Bob Lunney
Senior Database Engineer
AWeber Communications, LLC
1100 Manor Drive
Chalfont, PA 18914 USA
> On Jul 8, 2015, at 12:48 PM, Daniel Verite <daniel(at)manitou-mail(dot)org> wrote:
>
> Thierry Hauchard wrote:
>
>> When restoring from backup (created from 8.4 database with PG_Dump
>> 9.4.4), the log shows errors about UTF like :
>> 2015-07-07 17:03:35 CEST ERREUR: séquence d'octets invalide pour
>> l'encodage « UTF8 » : 0xf4 0x6c 0x65 0x20
>
> [...]
>
>> UPDATE test_table SET str_field = '\\' WHERE id = 75160909
>> -> ERROR: invalid byte sequence for encoding "UTF8": 0xee 0x6e 0x65
>>
>
> These sequences of bytes seem to come from LATIN1-encoded
> error messages from the backend, translated to french.
>
> 0xf4 0x6c 0x65 is "ôle" which could come from "rôle"="role" in
> english, a fragment of message that occurs routinely when
> restoring a dump granting permissions to roles that don't exist in
> the target cluster.
>
> 0xee 0x6e 0x65 is "îne" as in "chaîne" which is "string" in french. It's
> plausible that the above update, given standard_conforming_strings
> to false, produces the translated version of:
> "nonstandard use of \\' in a string literal"
> which is:
> "utilisation non standard de \\' dans une chaîne littérale"
> where non-surprisingly, the first non US-ASCII sequence is "îne"
>
> See how lc_messages is configured in postgresql.conf.
> Presumably it's French_France.1252 ?
>
> If you can live with english messages, set it to C, otherwise
> someone more knowledgeable in Windows might suggest a
> proper explanation and fix.
> Personally I don't understand in the first place how UTF-8
> is handled with '*.1252' locales, as cp1252 seems
> incompatible with UTF-8 by definition.
>
>
> Best regards,
> --
> Daniel
> PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Panchenko | 2015-07-08 17:17:29 | Re[2]: [GENERAL] PG 9.4.4 issue on French Windows 32 bits |
Previous Message | Adrian Klaver | 2015-07-08 16:54:40 | Re: PG 9.4.4 issue on French Windows 32 bits |