[Omirrow]

[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

[Freedom.]

Show your query and do you use escape string?

[Omirrow]

Quote:

Originally Posted by Freedom. 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.

[Freedom.]

yourvalue must be a text and change collation to 'utf8_general_ci' for your chat log table.

[Omirrow]

Quote:

Originally Posted by Freedom. 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.

[Freedom.]

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.

[Omirrow]

Quote:

Originally Posted by Freedom. 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]

I fixed it by using mysql set charset, thanks.