SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Thread Tools Display Modes
Old 27/07/2018, 11:23 PM   #1
Join Date: Apr 2018
Posts: 24
Reputation: 7
Default MySQL charset

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
Gr00t is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Charset Bigwebicek Scripting Help 1 15/12/2017 07:29 AM
Sublime 3 - Charset problem vannesenn Everything and Nothing 1 17/01/2016 06:55 PM
BlueG MySQL plugin - Failed (plugins/ undefined symbol: _Z13stringvprintfPKcPc) linuxthefish Plugin Development 10 13/07/2013 10:56 AM
Textdraw as charset Typhome Help Archive 1 20/03/2011 09:31 PM

All times are GMT. The time now is 03:15 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.