Open main menu

Changes

16 bytes added ,  01:30, 1 June 2018
no edit summary
The *recommended* charset/collation is 'binary BINARY'.
<source lang="mysql">
ALTER table <tablename> CHARACTER SET = 'binary ' COLLATE = 'BINARY';
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
4,558

edits