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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Converting to UTF-8 without shell access
1605
March 15, 2011 11:38AM


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.