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

2016-05-04 18:46 GMT+01:00 John Kendall <[email protected]>:
> 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