...
Code Block |
---|
mysqld] default-character-set=utf8 default-collation=utf8_generalunicode_ci |
Via the mySQL cmd tool:
Code Block |
---|
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; -- ALTER DATABASE frevvo CHARACTER SET utf8 COLLATE utf8_generalunicode_ci; ALTER TABLE formsubmission CONVERT TO CHARACTER SET utf8 COLLATE utf8_generalunicode_ci; -- SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |
...