mysql - encoding problem with non-latin strings

2008-12-04T16:52:25-04:00

i use eggdrop 1.6.19 with mysqltcl 3.05

Bot works nice, he can recognize russian and english letters, but i still have one problem..

I try to put some rus-lang string in database, f.e. "привет"

but i can see in phpmyadmin something like "ÌÀÃÈÍÀ"..

it was no problem, because when i did SELECT query with this string, i got original word - "привет".

Database (not -encode option in mysqltcl) encoding is UTF-8.

When i write "привет" in database through myadmin, and then SELECT this cell, i get only string with "?????"

Bot's encoding is not setted, same as mysqltcl -encoding option.

I tried to set them (both or only one of them) to utf-8, but i got another symbols of this string when looked at database's view in phpmyadmin.

i tested new database with cp1251 encoding, and it wont help.. I think its bot's problem.

Statistics: Posted by FallFromGrace — Thu Dec 04, 2008 4:52 pm

egghelp/eggheads community

mysql - encoding problem with non-latin strings