Re: VARCHAR query

Dennis Pimple wrote: Typo most of you caught without thinking about it: VARCHAR( 255, av ) instead of: > size of the string and define the column as VARCHAR(av,255) so that most > UPDATEs won't require moving/dividing the column. (When you define a VARCHAR( max, min ) instead of: > VARCHAR(min,max), the min size is always allocated, even if the number > of characters in the column is less than that number) > I'm glad I always read my own posts when they come up. //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer