Re: LENGTH function and trailing spaces

Posted in 1995

Kerry Sainsbury — Thu, 06 Apr 1995 00:29:30 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <3lscrr$3q3@dcsun4.us.oracle.com>, kbradley@130.35.1.6 (Kirk Bradley - Mainframe and Integration Technologies) wrote: > > Length is documented as returning the length of a character column, > not including the trailing spaces. What method do I use IN SQL to > get the REAL length of character column? i.e. what size would be > available to a program that fetched that column Try (approximately): SELECT syscolumns.colsize FROM syscolumns, systables WHERE syscolumns.tabid = systables.tabid AND systables.tabname = "YOURTABLE" AND syscolumns.colname = "YOURCOLUMN" "colsize" might be "collength" or something similar. > Kirk Bradley > Oracle Corporation ??????! - Kerry S PS: Kenny Everet is dead. I hope the funeral is "in the best possible taste!" --------------------------------------,------------------------------------- Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/* | mathcs.emory.edu:/pub/informix/faq/* +64 9 377-4473 (work) 279-3571 (home) | http://www.garpac.com/informix.html