SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 27/07/2018, 11:23 PM   #1
Gr00t
Banned
 
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:
Code:
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
Code:
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
Reply

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/mysql.so: 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 06:03 AM.


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