Enforcing Maximum Table Column Width

Generally, if a SQL statement attempts to save more data then is allowed by a column’s width, that data will be truncated. If you’d rather not write the data at all if it will not fit, use and specify the maximum allowed length in the MAXLENGTH attribute. This way an error will be thrown and the insertion (or update) will be aborted. (Applies to: ColdFusion 4.5 or later)

Leave a Reply