SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 09/07/2017, 09:59 PM   #1
Omirrow
Huge Clucker
 
Join Date: Feb 2013
Location: Turkey
Posts: 282
Reputation: 8
Post Had a MySQL problem, need help

[plugins/mysql] error #1366
Incorrect string value: '\xFDnda k...' for column 'myvalue' at row 1

How can I get rid of this problem?

(Using latest version of BlueG's MySQL)

myvalue is a varchar one (128 ), and the collation is latin5_turkish_ci
Omirrow is offline   Reply With Quote
Old 09/07/2017, 10:43 PM   #2
Freedom.
Big Clucker
 
Join Date: Oct 2012
Posts: 126
Reputation: 12
Default Re: Had a MySQL problem, need help

Show your query and do you use escape string?
Freedom. is offline   Reply With Quote
Old 10/07/2017, 08:09 AM   #3
Omirrow
Huge Clucker
 
Join Date: Feb 2013
Location: Turkey
Posts: 282
Reputation: 8
Default Re: Had a MySQL problem, need help

Quote:
Originally Posted by Freedom. View Post
Show your query and do you use escape string?
Yes, I do.

There isn't any syntax error or anything else in my query because it works without errors when I don't use Turkish characters and sometimes it still has the same problem even though I don't use Turkish characters.

I had a research on ****** for this and many other people had this problem before.
Omirrow is offline   Reply With Quote
Old 10/07/2017, 08:19 AM   #4
Freedom.
Big Clucker
 
Join Date: Oct 2012
Posts: 126
Reputation: 12
Default Re: Had a MySQL problem, need help

yourvalue must be a text and change collation to 'utf8_general_ci' for your chat log table.
Freedom. is offline   Reply With Quote
Old 10/07/2017, 08:45 AM   #5
Omirrow
Huge Clucker
 
Join Date: Feb 2013
Location: Turkey
Posts: 282
Reputation: 8
Post Re: Had a MySQL problem, need help

Quote:
Originally Posted by Freedom. View Post
yourvalue must be a text and change collation to 'utf8_general_ci' for your chat log table.
Why it shouldn't be a varchar one? Also, my main table's collation is also latin5_turkish_ci, I'll need to change it as well, if I'd want to change any of those values' collation from latin5_turkish_ci to utf8_general_ci


Anyways, I'll give this a try.
Omirrow is offline   Reply With Quote
Old 10/07/2017, 08:48 AM   #6
Freedom.
Big Clucker
 
Join Date: Oct 2012
Posts: 126
Reputation: 12
Default Re: Had a MySQL problem, need help

Here is my chat log table it should be something like that



Also do not change main collation just try what I say. It'll work.
Freedom. is offline   Reply With Quote
Old 10/07/2017, 09:59 AM   #7
Omirrow
Huge Clucker
 
Join Date: Feb 2013
Location: Turkey
Posts: 282
Reputation: 8
Post Re: Had a MySQL problem, need help

Quote:
Originally Posted by Freedom. View Post
Here is my chat log table it should be something like that



Also do not change main collation just try what I say. It'll work.
Should main collation be utf8_general_ci, it's default is latin1_swedish_ci (server sided default)

EDIT: It doesn't work, utf8_general_ci doesn't contain "İ" character, it doesn't support Turkish characters at all.
Omirrow is offline   Reply With Quote
Old 10/07/2017, 01:00 PM   #8
Omirrow
Huge Clucker
 
Join Date: Feb 2013
Location: Turkey
Posts: 282
Reputation: 8
Default Re: Had a MySQL problem, need help

I fixed it by using mysql set charset, thanks.
Omirrow 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
Password Hash Problem & MYSQL Saving Problem Faqahat Scripting Help 3 18/04/2016 11:54 AM
[PLUGIN]: MySQL Problem (MYSQL R39-2) zT KiNgKoNg Scripting Help 11 11/11/2014 06:20 PM
[Mysql problem] Loss of communication with the mysql base SmileyCoder General 0 29/05/2014 03:38 PM
saving system mysql(not mysql problem) martoivanov Scripting Help 0 29/08/2013 03:37 PM
Problem with reading money from MySQL in "Clean, Simple MySQL GM" by L3th4l Dystans Help Archive 1 31/05/2011 09:19 PM


All times are GMT. The time now is 08:18 PM.


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