1--echo # 2--echo # MDEV-4842 STR_TO_DATE does not work with UCS2/UTF16/UTF32 3--echo # 4 5SELECT @@character_set_connection, HEX(CAST(_utf8'÷' AS CHAR)); 6SELECT STR_TO_DATE(CAST(_utf8'2001÷01÷01' AS CHAR),CAST(_utf8'%Y÷%m÷%d' AS CHAR)); 7CREATE TABLE t1 AS SELECT REPEAT(' ', 64) AS subject, REPEAT(' ',64) AS pattern LIMIT 0; 8SHOW COLUMNS FROM t1; 9INSERT INTO t1 VALUES (_utf8'2001÷01÷01',_utf8'%Y÷%m÷%d'); 10SELECT HEX(subject),HEX(pattern),STR_TO_DATE(subject, pattern) FROM t1; 11DROP TABLE t1; 12 13