NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL 4 vs. 5 and character encoding (?)

Rahmin Pavlovic rahmin at insite-out.com
Wed May 10 12:21:34 EDT 2006


On 5/10/06 11:53 AM, "Daniel Convissor" <danielc at analysisandsolutions.com>
wrote:

> On Wed, May 10, 2006 at 10:57:53AM -0400, Rahmin Pavlovic wrote:
>> 
>> I already tried setting the charset / collation to utf-8 -- both on tables /
>> fields -- but resaving data produces the same mangled results.
> 
> How did you do that?  ALTER TABLE?  If so, that's too late.
> 
> Open up the SQL script created by mysqldump.  What's the default charset
> defined in the CREATE TABLE statements?
> 

latin1_swedish_ci.  When I ALTER TABLE, it successfully updates to
utf8_general_ci.  Why is it too late?  Do I need to re-dump?





More information about the talk mailing list