Skip to content

4.1. Extra: Database Setup

rtldg edited this page May 22, 2022 · 2 revisions

Database setup

The following issue may occur, depending on your database setup:

[shavit-core.smx] Timer error! Failed to insert "🔥 name with emojis 🔥 more poop here"'s data to the table. Reason: Incorrect string value: '\xDE\xAD\xBE\xEF...' for column 'name' at row 1

The solution is to change your database and users/chat tables' collation to utf8 or utf8mb4, see this MySQL article for information.

Note

Since version 3.1.0, another bug relevant to that insert-emoji thing was fixed. CS:S and TF2 can chop the last byte of a steam name off and corrupt Unicode characters. We chop off corrupted Unicode characters now. More info on the fix