Collation: Difference between revisions

@@ Line 92: / Line 92: @@
 <source lang="mysql">
 ALTER table <tablename> CHARACTER SET binary COLLATE BINARY;
+-- You can generate the above SQL commands with the following:
+SET @DATABASE_NAME = 'wiki_freephile';
+SELECT
+    CONCAT('ALTER TABLE `',
+            table_name,
+            '` CHARACTER SET binary COLLATE BINARY;') AS sql_statements
+FROM
+    information_schema.tables AS tb
+WHERE
+    table_schema = @DATABASE_NAME
+        AND `TABLE_COLLATION` = 'latin1_swedish_ci'
+        AND `TABLE_TYPE` = 'BASE TABLE'
+        AND `tb`.table_name NOT REGEXP '.*searchindex'
+ORDER BY table_name DESC;
 </source>