Oninit cdi / Archive
Talk to an expert →

ADO/Infx : How to remove trailing spaces

Posted in 2000

Topics: General Discussion

Eric BULEON — — source: Informix-list mailing list archive (1991-1998)

Hello When I SELECT a string from Informix with ADO, I always receive trailing spaces, so I always need to TRIM() the received string. Is there a way to automatically remove the trailing space for strings ? -- Eric Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Eric BULEON
Sergey E. Volkov — — source: Informix-list mailing list archive (1991-1998)

Use 'varchar' instead of 'char' in your db-chema and no problems! Eric BULEON <eric.buleon@oami.eu.int> ''''' ' ''''''''':8tu5cf$l1$1@nnrp1.deja.com... > Hello > > When I SELECT a string from Informix with ADO, I always receive > trailing spaces, so I always need to TRIM() the received string. > Is there a way to automatically remove the trailing space for strings ? > > > -- > Eric > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

↪ replying to Sergey E. Volkov
Neil Russell — — source: Informix-list mailing list archive (1991-1998)

Or use SELECT TRIM(BOTH FROM column_name),..... And your recordset contains no Leading or Trailing spaces. In article <8tu8av$66u1@www.informix.com>, "Sergey E. Volkov" <sve@raiden.bancorp.ru> wrote: > Use 'varchar' instead of 'char' in your db-chema and no problems! > > Eric BULEON <eric.buleon@oami.eu.int> ''''' ' > ''''''''':8tu5cf$l1$1@nnrp1.deja.com... > > Hello > > > > When I SELECT a string from Informix with ADO, I always receive > > trailing spaces, so I always need to TRIM() the received string. > > Is there a way to automatically remove the trailing space for strings ? > > > > > > -- > > Eric > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.