Problem with freebcp and fixed text output

Modesto Sevilla <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hello,
  I am evaluating freebcp as a replacement to bcp (Sybase) while 
connecting to MS Sql Server 2008.  My problem is that when I bcp out a 
table even if I specify a format file, the output does not come out in 
fixed length as it did with bcp. 

Here is an example:

Table:
create table testbcp
(
        term_code               char(3)         NOT NULL,
        cbs_term_code           char(6)         NOT NULL,
        description             char(10)        NULL,
        last_update_date        datetime        NULL
)

Format file:
10.0
4
1       SYBCHAR 0       3       ""      1       term_code
2       SYBCHAR 0       6       ""      2       cbs_term_code
3       SYBCHAR 0       10      ""      3       description
4       SYBCHAR 0       24      "\n"    4       last_update_date

Output when calling freebcp testbcp out testbcp.dat -f testbcp.fmt -S 
SERVER -U USERNAME -P PW

093200901TESTING DE
094200902TEST2009-08-04 16:28:11.780
092200906NO DESC2009-08-04 16:28:11.780

But it should be fixed length like this:
093200901TESTING DE
094200902TEST             2009-08-04 16:28:11.780
092200906NO DESC     2009-08-04 16:28:11.780

For some reason it is not padding with spaces according to the format 
file like the Sybase bcp tool does.
Can anyone help me?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.