Any way to limit the size of a TEXT datatype?

Posted in 2000

christophercale@my-deja.com — Mon, 01 May 2000 15:10:09 GMT — source: Informix-list mailing list archive (1991-1998)

All, Is there any mechanism that can be applied at the database level that will force a size limit to a TEXT datatype? ie.. if an application attempts to insert a TEXT value greater than x characters, the database will reject and notify the app. Thanks, Christopher Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to christophercale@my-deja.com

Art S. Kagel — Mon, 01 May 2000 13:59:33 -0400 — source: Informix-list mailing list archive (1991-1998)

christophercale@my-deja.com wrote: > > All, > > Is there any mechanism that can be applied at the database level that > will force a size limit to a TEXT datatype? ie.. if an application > attempts to insert a TEXT value greater than x characters, the database > will reject and notify the app. No you will have to place a trigger to check the length(textcolumn) and error out if too large. Art S. Kagel

↪ replying to Art S. Kagel

christophercale@my-deja.com — Tue, 02 May 2000 12:08:20 GMT — source: Informix-list mailing list archive (1991-1998)

Art, Thanks for your reply....I got it to work. Christopher In article <390DC605.65666C35@bloomberg.net>, kagel@bloomberg.net wrote: > christophercale@my-deja.com wrote: > > > > All, > > > > Is there any mechanism that can be applied at the database level that > > will force a size limit to a TEXT datatype? ie.. if an application > > attempts to insert a TEXT value greater than x characters, the database > > will reject and notify the app. > > No you will have to place a trigger to check the length(textcolumn) and > error out if too large. > > Art S. Kagel > Sent via Deja.com http://www.deja.com/ Before you buy.