Skip to Content.
Sympa Menu

freetds - Re: [freetds] freebcp in -n native switch not working with Sybase

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 in -n native switch not working with Sybase
  • Date: Tue, 10 May 2016 08:42:28 +0100

2016-05-04 18:46 GMT+01:00 John Kendall <john AT capps.com>:
> On MS SQL Server this works:
>
> select col1="one", col2="2" into tempdb..tbl
>
> freebcp tempdb..tbl out tbl.bcp -n -Uusr -Ppw
> freebcp tempdb..tbl in tbl.bcp -n -Uusr -Ppw
>
> On Sybase the bcp in fails like so:
>
> Starting copy...
>
> Msg 20104, Level 3
> Unexpected EOF encountered in bcp datafile
>
> bcp copy in failed
>
>
> Notes:
> The bcp file created is identical for on both server flavors.
> Using the character -c option works.
>
> Anyone else able to reproduce this problem?
>
>
> John
>

Looks like the way the prefix length is computed is different between
load and save time. For mssql works as varchar has a varint == 2, same
as prefix computed to write.

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page