Skip to Content.
Sympa Menu

freetds - [freetds] trailing spaces

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: RCS Computers <randy AT rcs-comp.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] trailing spaces
  • Date: Tue, 25 May 2004 14:39:16 -0500

Hello again,

I have found several posts that talk about trailing spaces in output from the freetds driver. I am connecting to a sybase database with php and from what I read, the reason I am getting spaces after the data I want is because the column is a CHAR column and the size of the data is < the size of the column.

Some things I have read suggest changing the DB structure. That is not an option. Some have suggested changing the php code, but I have been developing with the Sybase ODBC driver on a Windows system, which automatically trimmed the data, and that would entail a lot of changed code and checking for errors.

So, I would like to know if I can change the freetds in some way, either configuration or recompiliation, so that it mimics the Sybase ODBC driver and trims the data of spaces automatically?

Thank you in advance.

--------------------------------------
Randy Syring
RCS Computers

"For by grace you have been saved through faith [in Jesus Christ]; and that not of yourselves, it is the gift of God"
Ephesians 2:8




Archive powered by MHonArc 2.6.24.

Top of Page