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