fivem-mysql-async icon indicating copy to clipboard operation
fivem-mysql-async copied to clipboard

Fivem Database Error

Open Macecb opened this issue 2 years ago • 0 comments

Hey Guys, I have a database error when an user enters server with special character / icons in his name. I saw that on other servers this was not a problem so i am lookin for the right solution. Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xF0\x9F\x91\x8C I know this is related to utf8mb4. My Info: database - utf8mb4_general.ci (also unicode did not work) mysql connection string in server.cfg -set mysql_connection_string "mysql://username:password@localhost/database?charset=utf8mb4_general_ci&supportBigNumbers=true&multipleStatements=true"

It does not work whatever i do. But i saw on other server i was working on that it work.

IMPORTANT: It works perfect on localhost but not on hosted server (with panel)

Macecb avatar Sep 15 '22 21:09 Macecb