Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I convert my database and select utf8 as a connection charset, but all national symbols are corrupted (displayed as small squares or other wrong symbols). How can I solve the problem?

April 26, 2017charset connection convert corrupted database National select Symbols utf8

0

Posted

I convert my database and select utf8 as a connection charset, but all national symbols are corrupted (displayed as small squares or other wrong symbols). How can I solve the problem?

1 Answer

0

Posted

– Probably you use MySQL server earlier than version 4.1 and your MySQL data is not in utf8 charset. MySQL server earlier than v4.1 doesn’t support charset conversion. That it why you should set the same connection charset as configured on your server (usually latin1). I’ve got the following error message: “The dynamic link library SHLWAPI.dll could not be found in the specified path…” – Please, install Internet Explorer version 4.01 or later.