Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freebcp out from MS SQL Server drops spaces [NC]
  • Date: Fri, 10 Jul 2009 16:39:38 +0200

2009/7/10 Cedric ROUVRAIS <cedric.rouvrais AT sgcib.com>:
> 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




Archive powered by MHonArc 2.6.24.

Top of Page