Radicore Forum - RDF feed
type: channel
description: Fast Uncompromising Discussions. FUDforum will get your users talking.
items: MySQL tinyint not changeable to boolean
items: Re: MySQL tinyint not changeable to boolean

MySQL tinyint not changeable to boolean
type: item
description: 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
creator: markcarranza
date: 2013-01-21T22:19:50-00:00

Re: MySQL tinyint not changeable to boolean
type: item
description: 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.
creator: AJM
date: 2013-01-22T14:08:22-00:00