Skip to Content.
Sympa Menu

freetds - Re: [freetds] bcp CHAR behavior

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page