freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "James K. Lowden" <jklowden AT schemamania.org>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] bcp CHAR behavior
- Date: Fri, 16 Apr 2004 18:01:55 -0400
On Fri, 16 Apr 2004, Michael Peppler <mpeppler AT peppler.org> wrote:
> Note that the char(20) column is *padded* to the correct width, while
> the varchar() column is trimmed. I suspect that you will have to become
> a little more precise for char() columns, and either pad or truncate as
> needed to match the target column's width.
I suppose the best logic is to initialize the wire buffer to spaces, move
the data from the file into the buffer, and complain if it doesn't fit.
I'll look again. It might be that our char->char dbconvert() doesn't pad
out the target. It probably should.
Thanks, Michael.
--jkl
-
[freetds] bcp CHAR behavior,
James K. Lowden, 04/15/2004
-
Re: [freetds] bcp CHAR behavior,
Michael Peppler, 04/16/2004
- Re: [freetds] bcp CHAR behavior, James K. Lowden, 04/16/2004
-
Re: [freetds] bcp CHAR behavior,
Michael Peppler, 04/16/2004
Archive powered by MHonArc 2.6.24.