Open-AudIT
https://www.open-audit.org/phpBB3/

Increase the size of Manual Data Description field
https://www.open-audit.org/phpBB3/viewtopic.php?f=9&t=4303
Page 1 of 1

Author:  montebond [ Wed Feb 16, 2011 2:51 am ]
Post subject:  Increase the size of Manual Data Description field

I would like to increase the size of the manual data drescription field which seems to be limited to 99 characters I would like at least 300 inorder to document properly.
Montebond

Author:  montebond [ Wed Mar 02, 2011 3:43 am ]
Post subject:  Re: Increase the size of Manual Data Description field

I changed it to 360 with out an issue as of now

[code]ALTER TABLE `system_man` CHANGE `system_man_description` `system_man_description` VARCHAR( 360 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ''[/code]

if any one can find a reason not to do this I'm all ears
Montebond

Author:  jpa [ Wed Mar 16, 2011 4:25 am ]
Post subject:  Re: Increase the size of Manual Data Description field

VarChar > 255 doesn't work in MySQL 4. Just an FYI for future users running MySQL 4 (all 3 of them.)

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/