search

OllieJones / fast-woo-order-lookup

WooCommerce / WordPress plugin to speed up searches for orders
GNU General Public License v2.0
13 stars 1 forks source link

A bug in MySQL 5.5 and MariaDb 10.4 and before prevents building the trigram table #17

Closed OllieJones closed 3 months ago

OllieJones commented 3 months ago

In some older db versions, this

SELECT 12345 COLLATE utf8mb4_general_ci AS value

fails with a message saying Collation utf8mb4_general_ci is invalid for latin1

The workaround? 

 SELECT CAST(12345 AS CHAR) COLLATE utf8mb4_general_ci AS value

The bad versions? MariaDB 10.4 and earlier. MySQL 5.5 for sure, maybe 5.6 and earlier, 5.7 is OK.