Help with utf-8 chars in mysql query

[seopolis 0]

Does anybody knows how to handle a mysql query that inserts some utf-8 text into a table correctly ?

 

I tried everything (I checked db collation and fields are all utf8-general-ci), but always the text stored in db like this: 

 

???ed?? ??uh???

 

I think that the utf-8 encoding should be the default...

 

Any help will be very appreciated..

[blumi40 222]

where have u wrote the script?
if in a external editor like notepad  u have to save it with utf8 format and then copy to ubot  maybe that helps

[seopolis 0]

It's a simple .txt file that I saved with utf8 encoding, and then I read that file to populate a database. It's a simple task, but can not overcome this encoding thing..

 

Thanks blumi40 for your suggestion anyway.

[peleus 2]

Thanks. Other than utf8, are there other formats where ubot can read? 

[nktsitas 0]

Hello,

have you found a solution to the utf8 encoding problem?

I try to execute a simple mysql insert command with utf8 content and the result is ???????

[LoWrIdErTJ - BotGuru 904]

open file in notepad

file > save as

 

Follow video on drop down for the format. 

then use inside ubot however you like

 

http://screencast.com/t/5ufzcS59ZqW

[Hightower 2]

WOW... Thanks buddy awesome