Changes

Collation (view source)

16 bytes added , 00:30, 1 June 2018

no edit summary

The *recommended* charset/collation is 'binary BINARY'.

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