Changes

Collation (view source)

83 bytes added , 15:57, 21 January 2020

no edit summary

== Reference ==

http://kunststube.net/encoding/

== MediaWiki ==

Trying to Special:Import an XML dump from Special:Export of Commons, I get an "illegal mix of collations" error.

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

1,503

edits