Fast Uncompromising Discussions. FUDforum will get your users talking.
Here's a sample ALTER script ALTER TABLE `dict_table` ADD COLUMN `is_int_boolean` TINYINT NOT NULL DEFAULT 0 AFTER `revised_user`, ADD COLUMN `is_char_boolean` CHAR(1) NOT NULL DEFAULT 'Y' AFTER `is_int_boolean` ; After importing columns, - cannot update is_int_boolean to BOOLEAN - can update is_char_boolean to BOOLEAN http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq76 if I UPDATE dict_column.col_type_native to 'tinyint,boolean' then I can change it. I can see from previously imported columns that this used to work in (I think) 1.75
Re: MySQL tinyint not changeable to boolean
You should *NOT* be changing the dictionary database as it is part of the core product. Experiment on your own application tables until you know what you are doing.