Hello I have an issue with player coming on my Surf Server with names like 𝑫𝒂𝒓𝒍𝒊𝒏𝒈 ❤
They can get times and if they set an SR it says so. But they never get points are a rank. If you try to retrieve the info via !top or !maptop or !rank nothing populates.
I set my DB and all tables and collumns to use utf8mb4_general_ci. I have the name field collation and the char type for the name collumn set to utf8mb4_general_520_ci But nothing is helping this issue
Here are the queries I ran to convert my DB. ckSurf uses Swedish collation by default
Code:
//Change DB Collation & Char set
ALTER DATABASE cksurdev CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
Code:
// Change Table Collation
ALTER TABLE ck_bonus CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_challenges CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_checkpoints CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_latestrecords CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_maptier CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_playerchat CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_playeroptions CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_playerrank CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_playertemp CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_playertimes CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_playertitles CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_spawnlocations CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE ck_stages CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Code:
// Collumn collation
ALTER TABLE `ck_bonus` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_bonus` MODIFY `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_bonus` MODIFY `mapname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_challenges` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_challenges` MODIFY `steamid2` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_challenges` MODIFY `map` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_checkpoints` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_checkpoints` MODIFY `mapname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_latestrecords` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_latestrecords` MODIFY `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_latestrecords` MODIFY `map` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_maptier` MODIFY `mapname` varchar(54) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playerchat` MODIFY `steamid` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playerchat` MODIFY `tag` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_playerchat` MODIFY `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_playeroptions` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playerrank` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playerrank` MODIFY `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_playerrank` MODIFY `country` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_playertemp` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playertemp` MODIFY `mapname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playertimes` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playertimes` MODIFY `mapname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_playertimes` MODIFY `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `ck_playertitles` MODIFY `steamid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_spawnlocations` MODIFY `mapname` varchar(54) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_stages` MODIFY `steamid` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `ck_stages` MODIFY `map` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
__________________