Re: freebcp out from MS SQL Server drops spaces [NC]

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
2009/7/10 Cedric ROUVRAIS <[email protected]>:
> Hi Fred,
>
> I changed the code where James suggested I change the code.
>
> As it isn't my code, I followed his suggestion :o)
>
> The important part is the behaviour, the location of no importance to me.
>
> A++ Cedric
> --------------------------
> Sent with a mobile device.
>

I'm doing some test...
- NULLs become empty strings in both varchar and char.
- empty strings became a single NUL character for varchar and all
spaces for char
- varchar are not padded but keep spaces at the end
- char are padded with spaces

freddy77
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.