[Dspam-devel] Dspam and PostgreSQL

[Christophe G. <chr...@ga...>]

Hello there,

Hope I'll get more answers here than on the users-ML.
As the title suggests I'm trying to run Dspam (3.10.1) on a Debian 
machine with Postfix and PostgreSQL 9.1
Until now I had no success as all inserts in dspam_signature_data 
returned this error:
CEST ERREUR:  séquence d'octets invalide pour l'encodage « UTF8 » : 0xcf38
(Invalid Byte Sequence for UTF8 encoding)

Here is one example of those actual insert :
http://pastebin.com/YzX4FjgP

Then I tried a new database with an SQL_ASCII character set. And then 
the same insert works perfectly !
Does this mean we can't use UTF8 as the character set of a PostgreSQL 
database ? That sounds surprinsing to me.

Thanks in advance.

Christophe Garault