[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