Is MariaDB supported now?

[Fossil01]

I looked at old issues but couldn't find a definitive answer. Is MariaDB supported now in this package?

I'm running MariaDB 10.4.10

[freekmurze]

If MariaDB supports the same JSON function as MySQL then the answer is yes.

[Fossil01]

It doesn't, but I found numerous issues/PR's with possible changes to support both. What's the reason these are ignored?

[JJCLane]

I'm facing an issue with MariaDB json types and collations. The query works if you manually specify the collation e.g.

select * from tagswhere JSON_UNQUOTE( JSON_EXTRACT('name', '$."en"') ) collate utf8_unicode_ci like '%fish%'

Otherwise I receive the error: #1267 - Illegal mix of collations (utf8_general_ci,COERCIBLE) and (utf8_unicode_ci,COERCIBLE) for operation 'like'. The only way I've found to do that reliably is to update the wrapJsonSelector function in vendor\laravel\framework\src\Illuminate\Database\Query\Grammars\MySqlGrammar.php which is obviously not a solution.