Collation behavior

pedja's profile image pedja posted 14 years ago in General Permalink

I use HeidiSQL 5.0.0.3031.

Noticed strange behavior with setting collation. When set collation while creating new table or just changing collation for existing table, HeidiSQL does everything as expected. I check that using phpMyAdmin.

But, when I check collation in HeidiSQL, it is always not set (collation information shows empty value).

Also, if I check Create code option, collation info is missing form generated code.

The same thing happens with field collation. It looks like, for some reason, HeidiSQL does not read collation information. This is not critical issue but can confuse.

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