[syslog-ng] Encoding provlem when writing to postgres
ml at bortal.de
ml at bortal.de
Wed Oct 15 09:53:26 CEST 2008
Hello List,
i get the following error when i try to write to postres:
Error running SQL query; type='pgsql', host='XXX', port='', user='XXX',
database='syslogng', error='ERROR: invalid byte sequence for encoding
"UTF8": 0xe96461\x0aHINT: This error can also happen if the byte
sequence does not match the encoding expected by the server, which is
controlled by "client_encoding".\x0a', query='INSERT INTO msg_table
(msg_rcv_time, msg_sent_time, hostname, msg_facility, msg_priority,
msg_text) VALUES (\'2008-10-14T19:59:46+02:00\',
\'2008-10-14T19:59:46+02:00\', \'foo\', \'mail\', \'warning\',
\'mimedefang.pl[3497]: Message contains more than one Subject: header:
Bulletin d\\\'\'info d\\\'\'Enseigner.TV et la fiche p\xffdagogique de
l\\\'\'\xffmission du mois \xff 14 octobre 208 --> Bulletin d\\\'\'info
d\\\'\'Enseigner.TV et la fiche p\xffdagogique de l\\\'\'\xffmission du
mois \xff 14 octobre 208\')'
How can i fix this? I am running postgresql-8.1 with Debian 4.0.
Thanks,
Mario
More information about the syslog-ng
mailing list