Hello !
When i make a sample table with follow command:
CREATE TABLE `Test` (`aenum` ENUM('html','text','cms') NOT NULL DEFAULT 'text') COLLATE='latin1_swedish_ci' ENGINE=MyISAM;
Then Heide makes the column "aenum" type toi "TEXT" ?
Change does not work either.
On console a:
ALTER TABLE `Test` CHANGE COLUMN `aenum` `aenum` ENUM('html','text','cms') NOT NULL DEFAULT 'text';
is working. ?
My colleague has version 6, since it still works.
...Mhhhh
Can't create ENUM('html','text','cms') ... Heidi makes Columntype TEXT ?
Code modification/commit
from ansgar.becker,
10 years ago,
revision 8.3.0.4815
Restrict regular expression in TDBConnection.GetDatatypeByName to very left characters, so it does not detect "ENUM('text','...') DEFAULT 'text'" columns as TEXT type. See http://www.heidisql.com/forum.php?t=16271
Please login to leave a reply, or register at first.