Comments (1)

Default MySQL character set and collation

Filed in Coding, 15/02/2010, 15:12 by ,

Database:
ALTER DATABASE `db1` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci ;

Every table:
ALTER TABLE `table1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci