freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] trailing spaces

From: Dan Wierenga <dan AT hornytoad.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] trailing spaces
Date: Thu, 27 May 2004 13:16:17 -0700

Michael Peppler wrote:

The DBI documentation says that a driver may implement the ChopBlanks
statement handle attribute, and that if it doesn't, it should return
undef.

Actually it *does* work - but only on char() columns. varchars and
things that are treated as varchar (i.e. nullable char) isn't affected
as they *should* be trimmed already.

Varchar aren't padded... but ChopBlanks works as expected on both char and varchar columns.

-Dan

[freetds] trailing spaces, RCS Computers, 05/25/2004
- RE: [freetds] trailing spaces, Michael Sims, 05/26/2004
  - Re: [freetds] trailing spaces, Dan Wierenga, 05/26/2004
    - Re: [freetds] trailing spaces, Michael Peppler, 05/27/2004
- <Possible follow-up(s)>
- RE: [freetds] trailing spaces, Lowden, James K, 05/25/2004
- RE: [freetds] trailing spaces, Lowden, James K, 05/26/2004
  - Re: [freetds] trailing spaces, Dan Wierenga, 05/26/2004
  - RE: [freetds] trailing spaces, Michael Peppler, 05/27/2004
    - Re: [freetds] trailing spaces, Dan Wierenga, 05/27/2004
    - Re: [freetds] trailing spaces, James K. Lowden, 05/27/2004