[BUG] Collation conversion on table does not work

1 posts
[expired user #10182]'s profile image [expired user #10182] posted 8 years ago in General Permalink

Hi,

Changing collation on whole table in table properties never worked for me, but today I found that

HeidiSQL generates this SQL ALTER TABLE web_users COLLATE='utf8_czech_ci', CONVERT TO CHARSET utf8;

while working command would be ALTER TABLE web_users_session CONVERT TO CHARACTER SET utf8 COLLATE utf8_czech_ci;

If possible, please confirm this and fix would be nice.

I am using 9.3.0.5119 right now on Mysql 5.6.17.

Please login to leave a reply, or register at first.