AlliedModders - [SB++] Inserting ban "Incorrect string value"

AlliedModders (https://forums.alliedmods.net/index.php)

- SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)

- - [SB++] Inserting ban "Incorrect string value" (https://forums.alliedmods.net/showthread.php?t=329369)

[SB++] Inserting ban "Incorrect string value"

Hi,

Every time a new ban is added via the ingame admin menu, and the banned players ingame name contains unicode-characters (Ex. "𝖘𝖚𝖙𝖉𝖎") i get the following error in my "sourcebans.log":

Code:

L 12/21/2020 - 00:04:15: [sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xF0\x9D\x96\x98\xF0\x9D...' for column 'name' at row 1

My DB setup looks like this:

https://i.gyazo.com/546b4f6c0a702ac2...99c30307bb.png

Everything worked before i changed DB host... I have tried different SQL commands - also changing the "Charset" of the "name" column... But nothing have worked.

Versions:
MySQL: mysql-5.7.31
Sourcemod: 1.10.6501
Metamod: 1.11.1143
Sourcebans++: 1.6.3

Any ideas?

Re: [SB++] Inserting ban "Incorrect string value"

i had the same issue few months ago. open the sbpp_main.sp and change:

PHP Code:


		
			
SQL_SetCharset(DB, "utf8");

PHP Code:


		
			
SQL_SetCharset(DB, "utf8mb4");

and recompile the plugin.

do the same with the sbpp_comms.sp