How to reproduce:
- execute the commands below
- select database HeidiSQL_bugreport at left panel
- go to right panel and order tables by name
- you will find, that tables are not order alphabetically (see screenshot attached)
DROP DATABASE HeidiSQL_bugreport;
CREATE DATABASE HeidiSQL_bugreport;
CREATE TABLE HeidiSQL_bugreport.`40AB_Abc` (
`dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN_beta` (
`dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN100_beta` (
`dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN100_gamma_3` (
`dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`2SN100_alpha_1` (
`dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`lorem` (
`dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
CREATE TABLE HeidiSQL_bugreport.`ipsum` (
`dummy` VARCHAR(32) NOT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;