Collation: Difference between revisions
No edit summary |
No edit summary |
||
| Line 91: | Line 91: | ||
The *recommended* charset/collation is 'binary BINARY'. | The *recommended* charset/collation is 'binary BINARY'. | ||
<source lang="mysql"> | <source lang="mysql"> | ||
ALTER table <tablename> CHARACTER SET binary COLLATE BINARY; | ALTER table <tablename> CHARACTER SET = 'binary' COLLATE = 'BINARY'; | ||
| Line 98: | Line 98: | ||
SET @DATABASE_NAME = 'wiki_freephile'; | SET @DATABASE_NAME = 'wiki_freephile'; | ||
SELECT | SELECT | ||
CONCAT( | CONCAT("ALTER TABLE `", | ||
table_name, | table_name, | ||
"` CHARACTER SET = 'binary' COLLATE = 'BINARY';") AS sql_statements | |||
FROM | FROM | ||
information_schema.tables AS tb | information_schema.tables AS tb | ||