The MySQL docs have got a pretty good section on this: http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
You may need to convert the columns to BLOBs before you can safely convert to UTF8. Also note that each non-trivial ALTER TABLE statement will mean a table copy... James 25-02 at 13:40 +0100, Christopher Arndt wrote: > > > iain duncan schrieb: > > > Can anyone tell me what the proper settings are for mysql to make it > > > play fair with python utf-8 unicode? > > > Maybe this doc will help? > > >http://docs.turbogears.org/1.0/DatabaseMySQL#using-utf-8-encoding-wit... > > Also, that doc shows how to alter the character set for a db that > already exists. Is this safe to do if there is already content in it? > > Thanks! > Iain --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
