Search Postgresql Archives

Re: PG 9.4.4 issue on French Windows 32 bits (SOLVED)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Thanks very much Daniel !  :))
You hit the problem.

lc_messages were configured with  'French_France.1252' (as usual)
Setting it to 'C' resolve the issue.
Another way is to set client_min_messages  to  'error'

So, it seems that a 32 bits PG 9.4.4 return to client the UTF8 error generated by log translation, and not the 64 bits version or older versions (same conf file) !

Thanks very much !

Best regards,
--
Thierry Hauchard
Gesteam

Le 08/07/2015 18:48, Daniel Verite a écrit :
	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,




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux