… -dvv table.MYI MyISAM file: table.MYI Record format: Packed Character set: utf8_general_ci (33) File-version: 1 Creation time: 2006-06-17 3…
Post: Converting Character Sets
March 17, 2009 By 16 Comments
… a database (or set of tables) to a target character set and collation. Approach #1: ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Take the… (0.02 sec) mysql> ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Query OK, 0 rows affected (0.02 sec) Records: 0Â…
