Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page