I have just installed XAMPP 5.6.21 on a system running Mac OS 10.11.5. All usage of the term REGEXP within my SQL queries are returning ERROR 1139 (42000): Got error 'this version of PCRE is compiled without UTF support at offset 0' from regexp
MariaDB [NBA]> SELECT 'a' REGEXP '^[a-d]';
ERROR 1139 (42000): Got error 'this version of PCRE is compiled without UTF support at offset 0' from regexp
MariaDB [NBA]> SELECT * FROM `data_team` where `city` REGEXP 'New York';
ERROR 1139 (42000): Got error 'this version of PCRE is compiled without UTF support at offset 0' from regexp
Can anyone explain why this is happening and what I can do to solve it? Downloading and recompiling PCRE would be a painful option and I would need suggestions for doing it correctly. I don't even know what PCRE is exactly other than picking up `Perl Compatible Regular Expressions` while investigating this error