[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