Hi @Jeremy_Jones,
The “ideal” set-up would be (inconsistencies intentional)…
client_charset = utf-8
connection_charset = utf8
database_charset = utf8
However, if your data is not encoded with those settings in place it may also be necessary to transcode your database. I’d suggest making a quick test with those settings enabled; if it doesn’t fix the issue, return them to what they were and we can consider next steps.
Regards,
Alec Smecher
Public Knowledge Project Team