Re: "Incorrect string value"

Alan Sparks <[email protected]> Sun, 1 Jan 2023 22:53:06 -0700
Newsgroups gmane.mail.virus.maiamailguard
Message-ID <[email protected]>
On 1/1/2023 8:06 PM, Alan Sparks wrote:
>
> Jan  1 20:00:51 zeus maiad[25275]: (25275-02) TROUBLE in check_mail: 
> spam_scan FAILED: DBD::mysql::st execute failed: Incorrect string 
> value: '\\xF0\\x9F\\x8E\\x86 2...' for column 
> `maia`.`maia_mail`.`subject` at row 1 at /var/lib/maia/maiad line 
> 3841, <GEN22> line 897.
>
I think I resolved the issue here by changing this to the "utf8mb4" 
variant of the field:

MariaDB [maia]> alter table maia_mail modify subject varchar(255) 
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Wonder if anyone else has had this issue.  Thanks.

-Alan


_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users