| MySQL tinyint not changeable to boolean [message #3351] |
Mon, 21 January 2013 17:19  |
markcarranza
Messages: 14
Registered: December 2012
Location: San Francisco, CA, USA
|
Junior Member |
|
|
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
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
