I ran into this problem while trying to create a product. I use XAMPP on my Mac. When I hit the save button, it gives this error.

`SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'this version of PCRE is compiled without UTF support at offset 0' from regexp, query was: SELECT MAX(ABS(CAST(SUBSTRING(`value`, 5, LENGTH(`value`) - 4) AS SIGNED))) FROM `catalog_product_entity_url_key`

This error is as a result of this version of PCRE is compiled without UTF support at offset 0. Run the below code from your terminal to be sure this is the issue

/Applications/XAMPP/xamppfiles/bin/pcretest -C

the output should look like this:

Fixing this is easy...here is how

1. Download PCRE from this site: https://sourceforge.net/projects/pcre/files/pcre/8.38/

2. Extract the folder and execute this command

./configure --prefix=/Applications/XAMPP/xamppfiles --enable-utf8 --enable-unicode-properties

make

sudo make install

3. Wait till compiling is over and then copy newly created library into your lib folder

$sudo cp .libs/* /Applications/XAMPP/xamppfiles/lib

// if needed execute this line as well
$sudo cp .libs/* /Applications/XAMPP/xamppfiles/bin

4. Check the UTF support again

Please retart your XAMPP Server.

Hope this helps someone.