I checked my database and it is using utf8_general_ci for the collation, so it was probably incorrect when I told you to use utf8_unicode_ci

Hope it helps,

Joe

Hi,

nope now all of my tables collation utf8_general_ci

Are you 100% sure of that? Have you inspected the collation on specific table columns? Column collation could be different than table collation.

The only thing I know is when I installed MySql I set utf8 and collation at install time and it is the default for the installation. Maybe making it the default just for a database is not enough if the installation has different settings as the default.

Hope it helps,

Joe

Do you have this as part of your connection string?

Charset=utf8;

Hope it helps,

Joe

That will most likely fix it. After you edit user.config make sure to touch (type a space and save it) web.config so it reloads the settings.

Best,

Joe

Hi,

I see, I did not include that part in the sample MySqlConnectionString in user.config. I will fix that now so it wil be more obvious in future releases.

Best,

Joe