MySQL Forums
Forum List  »  PHP

Re: problem with PhpMyAdmin
Posted by: Rick James
Date: July 10, 2016 01:35PM

So, the summary is that you had some utf8 text stored in a 4.0 MySQL? And things messed up during the upgrade to a recent version?

First, let's check the contents via

SELECT col, HEX(col) FROM ...

For "provençal", you might get

70 72 6F 76 65 6E C3A7 61 6C (no spaces) if it is utf8-encoded, or
70 72 6F 76 65 6E E7 61 6C if it is latin1-encoded.

Then, show us the table declaration (SHOW CREATE TABLE)

Probably the next step will be the 2-step ALTER shown here:
http://mysql.rjweb.org/doc.php/charcoll#2_step_alter
However, that may make things worse. So, answer my questions first.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.