[freetds] freebcp out from MS SQL Server drops spaces [C1]

Cedric ROUVRAIS cedric.rouvrais at sgcib.com
Mon Jul 6 13:21:08 EDT 2009


Hi guys,

We have several views that we use to format files that have to be sent to
external applications and we have an issue that we have been unable to
resolve. The Free BCP command drop trailing spaces (or inserts tabs) which
mucks up the file.

Usually what we do (with Sybase and MS SQL bcp it works just fine), is

      bcp dbInstance.dbUser.dbView out formattedFile.dat -c -t"" ...

FWIW, we're running bcp from Linux.

Any insight would be appreciated :o)

Thanks,

Cedric


*************************************************************************
This message and any attachments (the "message") are confidential, intended 
solely for the addressee(s), and may contain legally privileged information.  
Any unauthorised use or dissemination is prohibited.  E-mails are susceptible 
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************



More information about the FreeTDS mailing list