bcp/datacopy bit columns TDS 5.0

John Kendall <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
I'm using Sybase (TDS 5) and am running into a problem using datacopy (from 0.91) when a table has more than one bit column.  
The problem is easy to reproduce:

          create table tempdb..bob (bit1 bit, bit2 bit)
          insert tempdb..bob values (1,0)

          $ datacopy -c dbo -S SRV/usr/pw/tempdb/bob -D SRV/usr/pw/tempdb/bob2 
          Msg 4837, Level 16, State 2
          Server 'SRV', Line 1
                  Bad row data received from the client while bulk copying into object 1328007762 in database 2. Received a row of length 4 while maximum possible row length is 3.

          Msg 4837, Level 16
          General SQL Server error: Check messages from the SQL Server

          bcp_done failed.  
          datacopy: table copy failed.
                     the data may have been partially copied into the target database 
 

I searched the archives and found this thread:

   "bcp currently broken for BIT type in TDS 5.0"  
   http://lists.ibiblio.org/pipermail/freetds/2006q4/020788.html

I couldn't find anything more about it.  I realize it was almost 8 years ago, but does anyone have any more info?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.