MySQL – Regular expression replace

As of MySQL 8.0 and MariaDB 10 we can use  native REGEXP_REPLACE function. See also See MariaDB docs and PCRE Regular expression enhancements. — REGEXP_REPLACE(col, regexp, replace) SELECT REGEXP_REPLACE(“stackoverflow”,...

Mysql utf8_general_ci vs utf8_unicode_ci

Why to use utf8_unicode_ci over utf8_general_ci, or simple why never not to use utf8_general_ci. Basically utf8_general_ci is a broken version of utf8_unicode_ci. It is slightly faster bit only a little bit and it can produce unexpected result while sorting or...