This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELIMITER $$ | |
CREATE FUNCTION maybe_utf8_decode(str text charset utf8) | |
RETURNS text CHARSET utf8 DETERMINISTIC | |
BEGIN | |
declare str_converted text charset utf8; | |
declare max_error_count int default @@max_error_count; | |
set @@max_error_count = 0; | |
set str_converted = convert(binary convert(str using latin1) using utf8); | |
set @@max_error_count = max_error_count; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MYSQL SLUG FIX | |
The table 'content' contains pages with a slug. This slug should be unique but it isn't. | |
unique_fix.sql fixes this problem and makes the slug-column unique. |