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