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

Re: MySQL tinyint not changeable to boolean [message #3359 is a reply to message #3351]

Tue, 22 January 2013 09:08

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

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.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

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: Sun Nov 24 02:27:16 EST 2024

Total time taken to generate the page: 0.00970 seconds