DB and fields are UTF8_unicode_ci collation - MySql v 5.6
HTML charset is utf 8
Double byte script was entered successfully prior to this issue (Chinese, Japanese, plus Cyrillic etc) when using plain non encrypted input.
But trying to use AES_ENCRYPT on input mangles all non-english script. DB field is BLOB.
UPDATE mytable SET bodytext=AES_ENCRYPT('任車心是，防少劇和的；子反華不就','aeskey') WHERE t_id=123
produces strings of question marks - English is fine though
I'm not sure if I should try to CONVERT the input to UTF8 first - but when I try that I get an error. Any suggestions of what to review?