I have understood in principle how to convert an existing database from latin to utf8. I have already been able to do this successfully with the database I have.
The existing data is in Hungarian. The database fields were previously set to latin1_german1_ci. As a result, words were stored in the database in this way:
Mária
but in the frontend correctly shown as:
Mária
If I now convert everything to utf-8, it works as it should for all new data. But the existing data was not converted in the database and is displayed in the frontend exactly as it is in the database:
Mária
Which makes sense to me because it is utf8. But it is not what I want of course. But how do I get all the existing data in the database to be converted to e.g. "Mária" in first place?
No comments:
Post a Comment