ALTER DATABASE `database` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ALTER TABLE `table` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
I think there might be a command you need to run for the columns as well, I'm not sure. I always use InnoDB which doesn't support column character sets (I think). I think all that's sufficient is to set the character set on the database and then all tables created within will inherit that. I believe in my.cnf you can do: [mysqld] default_character_set = utf8 I'm not sure though, I like to keep my servers as close to the reference as possible to avoid obscure bugs when moving to third party servers. -Rob Baruch wrote: > No. The default appears to be latin1. > > I can't seem to find how to turn MySQL to default to utf-8, there is > the SET NAMES command, but there is no bvious way to use it in > SQLObject. > > Baruch > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
