Re: Auto Truncate of Spaces

Jake Colman wrote: > Is there a way to arrange for CHAR data fetched from the database to be > auto-truncated of any trailing spaces? I do NOT want to use the TRIM > function for each column to be truncated. I am looking for a lower-level > solution, perhaps using some ODBC parameter. > > Thanks! > Using a varchar instead of a char would not have any trailing spaces. If you use 4GL you can use CLIPPED to truncate trailing spaces. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------