Skip to Content.
Sympa Menu

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 vodafoneomnitel.it>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: turn off padding of CHAR with spaces?
  • Date: Wed, 18 Sep 2002 11:37:12 +0200


>
> Hi all,
>
> I've recently upgraded my FreeTDS to version 0.60 and now
> find that when I
> run a SELECT query from PHP, the reply now comes back padded
> with spaces
> to the length of the field on the database. This did not happen
> previously.
>

Hi

What database type do you use (CHAR/VARCHAR) ?
What library do you use? ctlib/dblib/odbc ?

Some version of db return CHAR tabbed and library return this characters...

> This has broken some code and I am wondering if there is
> someway to stop
> this particular behaviour. Just out of curiosity, is this a
> feature or a
> bug?
>

If CHAR this should be the correct behaviour...
However this is still a TODO.

>
> I am running a PHP 4.2.2 + FreeTDS 0.60 setup on a FreeBSD
> 4.2/Intel box,
> talking to an MS-SQL 7 server running NT 4.
>
> Any help would be greatly appreciated.
>
> Thanks,
> Chris Hernandez.
>

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page