Raised This Month: $32 Target: $400
 8% 

Incorrect string value on insert DB


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
TheFlyingApple
Member
Join Date: Aug 2016
Old 12-21-2020 , 08:59   Incorrect string value on insert DB
Reply With Quote #1

Hello,

Ever since i changed host of my Database, I have this weird error every time my plugins try to upload data to the DB. The error looks like this:

Code:
[sbpp_main.smx] Verify Insert Query Failed: Incorrect string value: '\xF0\x9D\x96\x98\xF0\x9D...' for column 'name' at row 1
I have allready checked my Database configuration and all column are of the type 'utf8mb4_unicode_ci' and my 'my.cnf' (Global database config) looks like this:

Code:
[mysqld]
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4
init-connect='SET NAMES utf8mb4'

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4
I know it's a DB problem and i have scoured the internet, but i have come up empty handed... Please help
TheFlyingApple is offline
Fyren
FyrenFyrenFyrenFyrenFyren FyrenFyrenFyrenFyrenFyren FyrenFyrenFyrenFyrenFyren FyrenFyrenFyrenFyrenFyren
Join Date: Feb 2106
Old 12-29-2020 , 20:42   Re: Incorrect string value on insert DB
Reply With Quote #2

You probably have to use SQL_SetCharset/db.SetCharset in your plugin to set utf8mb4.
Fyren is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 20:33.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode