Changes between Version 49 and Version 50 of MySqlDb

Timestamp:

Feb 5, 2010, 2:06:15 PM (14 years ago)

Author:

anatoly techtonik <techtonik@…>

Comment:

finally! the proper way to convert collation for tables

MySqlDb

@@ -109 +109 @@
 
 ==== Collation from "whatever" to "utf8_bin" ====
-First modify DB collation:
+First modify DB collation to ensure new tables will be created properly:
 {{{
 ALTER DATABASE `trac_database` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
 }}}
 
-Then modify tables - issue the following for every table:
+Then modify collation for tables. The command below changes default collation for new columns and converts old columns as well. Issue it for every table:
 {{{
-ALTER TABLE `table_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
+ALTER TABLE `table_name` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
 }}}