Re: Converting to UTF-8 without shell access
Posted by:
Rick James
Date: March 15, 2011 11:38AM
First, you need to understand how the settings and processing works.
http://forums.mysql.com/read.php?103,411540,412054#msg-412054
http://mysql.rjweb.org/doc.php/charcoll
* study CONVERT(), ALTER TABLE, etc.
* Find what settings exist in PhpMyadmin.
There is some chance that you have converted it correctly, but things look wrong. The only sure way to know if the data is 'correct' is with HEX and other tips in the web page above.
PhpMyadmin lets you enter SQL statements in one of its windows. Go there and pretend you are in the commandline mysql. It's at least close.
Subject
Views
Written By
Posted
5007
March 14, 2011 09:30AM
Re: Converting to UTF-8 without shell access
1753
March 15, 2011 11:38AM
2133
March 15, 2011 04:11PM
2165
March 15, 2011 09:03PM
1580
April 14, 2011 11:58AM
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.