maintenance issue

[expired user #4516]'s profile image [expired user #4516] posted 14 years ago in General Permalink
i`ve set change default charset to UTF8-general-ci and convert to charset to UTF8 on bulk table editor tab

the result is my tables are now in big5-chinese-ci charset :)
the query generated by maintenance page is

ALTER TABLE `db`.`table` COLLATE utf8_general_ci, CONVERT TO CHARSET big5;

instead of utf8
ansgar's profile image ansgar posted 14 years ago Permalink
There are two different options for that:
[ ] Change default collation
[ ] Convert to charset

What did you select in both pulldowns?
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
Change default collation - utf8_general_ci
Convert to charset - UTF-8 Unicode (utf8)
both selected
version 2824
ansgar's profile image ansgar posted 14 years ago Permalink
Oh yes, can confirm that. Shit. Will fix.
Code modification/commit from ansgar.becker, 14 years ago, revision 2825
Fix offset in charset table, always set to 0. See http://www.heidisql.com/forum.php?t=4638
ansgar's profile image ansgar posted 14 years ago Permalink
Fixed in r2825
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
more bugs to come :)
on maintenance window bulk table editor tab after applying converts as above (reopen after update),
in Change default collation - big5-chinese-ci is prepoppulated
in Convert to charset - EMPTY select!
ansgar's profile image ansgar posted 14 years ago Permalink
Yes, thanks for the notice - fixed in r2826.

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