AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting (https://forums.alliedmods.net/forumdisplay.php?f=107)
-   -   Can't compile regex expression. (https://forums.alliedmods.net/showthread.php?t=309240)

T1MOXA 07-23-2018 07:31

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...

T1MOXA 08-22-2018 19:23

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 ?

Fyren 08-22-2018 20:19

Re: Can't compile regex expression.
 
That error appears to mean you have bytes that can't be a valid UTF8 character.

T1MOXA 08-23-2018 06:06

Re: Can't compile regex expression.
 
Quote:

Originally Posted by asherkin (Post 2605175)
You should really consider switching to the utf8mb4 charset.

Quote:

Originally Posted by asherkin (Post 2605226)
No you won’t, the input/output is still UTF-8, it just allows characters outside of the BMP to be stored.

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

Fyren 08-23-2018 19:44

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.

T1MOXA 08-29-2018 16:56

Re: Can't compile regex expression.
 
Quote:

Originally Posted by Fyren (Post 2611894)
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.

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

T1MOXA 09-16-2018 21:05

Re: Can't compile regex expression.
 
Thank you, not knew about this rule.
Okay, how do I solve my problem ?
@asherkin not responding.

T1MOXA 09-16-2018 21:07

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 ?


All times are GMT -4. The time now is 03:07.

Powered by vBulletin®
Copyright ©2000 - 2022, vBulletin Solutions, Inc.