SA-MP Forums Archive
MySQL charset - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL charset (/showthread.php?tid=656934)



MySQL charset - Gr00t - 27.07.2018

What mysql charset should I use?, I'm migrating my server from sqlite to mysql and when trying to import all to mysql I got this syntax error:
Код:
ERROR 1064 (42000) at line 4728: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Ndrangheta', -6749953);
INSERT INTO crews VALUES (31, 'Ej├®rcito Nacional ', ' at line 1
Line in .sql file
Код:
INSERT INTO crews VALUES (31, 'Ejйrcito Nacional ', 232790271);
I know it's a charset error, .sql file is UTF-8