Re: Can't compile regex expression.
 

Then I get errors like this:
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

...


Although it seems that this problem is due to incorrect database encoding...

Re: Can't compile regex expression.
 

Today I encountered an error "Incorrect string value: '\xF0\x9F\x92\x8B\xF0\x9F...' for column 'name' at row 1".
The database is encoded utf8mb4_general_ci.
The column too.
What else could be the problem ?

Re: Can't compile regex expression.
 

That error appears to mean you have bytes that can't be a valid UTF8 character.

Re: Can't compile regex expression.
 

I did just that.
Just changed the encoding in the database.

Re: Can't compile regex expression.
 

If you're sure you've set the table and column charsets, in your plugin you can try (SQL_)SetCharset if using 1.10 or maybe doing SET NAMES 'utf8mb4' if not to set the connection's charset.

Re: Can't compile regex expression.
 

Yes, this probably would solve the problem, but this option is not suitable because too many plugins use the database, and will have to rewrite everything.
It is easier to remove the symbol with a regular expression, but for some reason it does not work on SM.
I am interested to hear @asherkin

Re: Can't compile regex expression.
 

Thank you, not knew about this rule.
Okay, how do I solve my problem ?
@asherkin not responding.

Re: Can't compile regex expression.
 

I have 2 problems at the moment.
1. Regex expresion to remove emoji not working
2. utf8mb4_general_ci encoding didn't help


database charset - utf8mb4
database collation - utf8mb4_general_ci
table collation - utf8mb4_general_ci
row collation - utf8mb4_general_ci

What's wrong ?