Bureaucrats, confirmed, Administrators
4,558
edits
Changes
Jump to navigation
Jump to search
no edit summary
<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>
