[Pkg-dspam-misc] Bug#731093: libdspam7-drv-pgsql: dspam logs showing invalid byte sequence

[Adrien Clerc]

Hi,

I got exactly the same behavior since upgrade to last package. Before 
that, I got something like this in /var/log/postgresql/:

2013-12-05 18:58:49 CET ATTENTION: utilisation non standard de \\ dans 
une chaîne littérale au caractère 127
2013-12-05 18:58:49 CET ASTUCE : Utilisez la syntaxe de chaîne 
d'échappement pour les antislashs, c'est-à-dire E'\\'.
2013-12-05 18:58:49 CET LOG: instruction : INSERT INTO 
dspam_signature_data (uid,signature,length,created_on,data) VALUES 
(4,'52a0bed916707
9777898567',4392,CURRENT_DATE,'\\x0000d0 [truncated…]

(Basicaly, it say to use escape sequence for backslashes, instead of \\x 
inside the value)

After upgrade, I got:

2013-12-04 13:55:53 CET ERREUR: séquence d'octets invalide pour 
l'encodage « UTF8 » : 0xf6 0x33 0x65 0x30
2013-12-04 13:55:53 CET INSTRUCTION : INSERT INTO dspam_signature_data 
(uid,signature,length,created_on,data) VALUES (4,E'529f2659145699019
213421',1644,CURRENT_DATE,E'\xf63e0 [truncated…]

So exactly the same message. And exactly the same behavior as reported, 
if I try to decode this in Python. The signature seems to be wrong. I 
can provide you a simple email if you like.

Adrien