Radicore Forum: Bug Reports » MySQL tinyint not changeable to boolean

Home » RADICORE development » Bug Reports » MySQL tinyint not changeable to boolean

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

[Message index]

		MySQL tinyint not changeable to boolean By: markcarranza on Mon, 21 January 2013 17:19
		Re: MySQL tinyint not changeable to boolean By: AJM on Tue, 22 January 2013 09:08

Previous Topic:	sample v3.0.0 validation error
Next Topic:	Tabs in php files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 11 12:26:53 EDT 2025

Total time taken to generate the page: 0.19264 seconds