NYCPHP Meetup

NYPHP.org

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

Rahmin Pavlovic rahmin at insite-out.com
Thu May 11 12:51:42 EDT 2006


On 5/10/06 8:10 PM, "Daniel Convissor" <danielc at analysisandsolutions.com>
wrote:

>> When I ALTER TABLE, it successfully updates to
>> utf8_general_ci.  Why is it too late?  Do I need to re-dump?
> 
> Because importing to a latin1 table modifies the original UTF-8 data --
> assuming it was UTF-8, of course.
> 

So -- just so I get this straight -- say I ALTER TABLE to set the default
character set to be UTF-8, then insert a brand new record filled with
high-bit chars, it will still not be able to read certain characters and
introduce '?' and whatnot in their stead?





More information about the talk mailing list