NYCPHP Meetup

[Daniel Convissor]

On Wed, May 10, 2006 at 12:21:34PM -0400, Rahmin Pavlovic wrote:
> 
> On 5/10/06 11:53 AM, "Daniel Convissor" <danielc at analysisandsolutions.com>
> wrote:
> 
> > 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.

That's the character set you got when dumping from MySQL 5?  You said you 
had the unusual characters working nicely in MySQL 5.  But how can that 
be if you had the character set as latin1?


> 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.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409