Tuesday, January 16, 2007

IE Database Bug Fix

The Actions and Improvements box on the IE interface has a bug in the database. The character limit is set to 45 instead of to TEXT. Here's the SQL to fix it.

ALTER TABLE `IGOR`.`IE_Objectives` MODIFY COLUMN `Improvements` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';

0 Comments:

Post a Comment

<< Home