Problem encoding German special characters/umlauts when using client_charset = utf-8, database issue [OJS 3.3.0.5]

Software Support
4

Hi @ewhanson,

please excuse my late reply.

I finally managed to convert the latin1 characters in our database to UTF-8 characters. I did not use the method mentioned above, but instead used the following SQL command and executed it for each affected table in the database.

SQL command for the table email_templates_default_data:

UPDATE email_templates_default_data SET 
    subject=convert(cast(convert(subject using  latin1) as binary) using utf8),
    body=convert(cast(convert(body using  latin1) as binary) using utf8),
    description=convert(cast(convert(description using  latin1) as binary) using utf8) 
WHERE 1

This method took a few minutes, but was effective and did not produce any other errors.

Kind regards,
Michael

1 Like