Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Collation behavior

pedja's profile image pedja posted 10 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.