Dspam and PostgreSQL

Christophe Garault <[email protected]> Tue, 21 Aug 2012 15:28:53 +0200
Newsgroups gmane.mail.spam.dspam.devel
Message-ID <[email protected]>
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

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
Dspam-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-devel
smime.p7s (application/pkcs7-signature, 5.3 KB) - not displayed