freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] RE: turn off padding of CHAR with spaces?

From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
To: "Georg Hitsch" <g.hitsch AT mitacs.com>, <freetds AT lists.ibiblio.org>
Cc:
Subject: [freetds] RE: turn off padding of CHAR with spaces?
Date: Mon, 11 Aug 2003 15:58:07 +0200

>
> Dear Frediano,
>
> Have you found a solution for
> "turn off padding of CHAR with spaces"
> (https://lists.ibiblio.org/sympa/arc/freetds/2002q3/009012.html
> )
>
> Thank you in advance!!
>
> Georg

Hi Georg!

Please post to mailing-list, not to me!

The solution depend from type and from library. dblib return CHAR
padded. This is the correct behavior. To remove spaces use RTRIM in
query or VARCHAR type.

freddy77

[freetds] RE: turn off padding of CHAR with spaces?, ZIGLIO Frediano, 08/11/2003
- <Possible follow-up(s)>
- RE: [freetds] RE: turn off padding of CHAR with spaces?, Lowden, James K, 08/11/2003