[thelist] mySQL - mass change of collation

Mark envoy at sonic.net
Sun Apr 29 21:22:54 CDT 2007


This default collation can be set at the table level an probably the
database level so new field will be create with the value you specify

CREATE TABLE `test_2` (
`field1` INT NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

Create the database and/or tables yourself.

If your backup was saved a sql then just a search and reploce on the
scripts before importing  would be sufficient.

If you can set this at the database level even this would become
unnecessary.



More information about the thelist mailing list