Importing UTF8 Characters into MySql

[mihir.d.parmar]

Hello

My question is about importing UTF8 characters into MySql via 2 methods. One via MySql import feature and second via inserting using a tool created in Visual Basic. The tables are utf8/utf8_general_ci

To quote a simple example, I am trying to import the following words "České Budějovice". I have saved this content in a utf8 saved csv file.

- Using MySql import feature, it imports perfectly and looks like the following when viewed with two MySql Browsers:

MySQLFRONT - České Budějovice
SQLYOG - České Budějovice

- Now when I import this exact same file using the exe that I created in VB and try to import it both with and without utf8 option, it looks like following

With UTF8 Encoding,

MySQLFRONT - České Budějovice
SQLYOG - České Budějovice

Without UTF8 Encoding,

MySQLFRONT - Ceské Budejovice
SQLYOG - Ceské Budejovice

I have no idea why it is happening like this. I am even importing it as utf8. Any Inputs would be appreciated.

Thanks.