FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

James K. Lowden wrote:
> bcp is broken for NULL character data.  I don't know when that happened
> or if it ever worked.  Our unit test is more of a smoke test; it doesn't
> ensure the data make a happy round trip.  

Correction: bcp is broken for TDS 5.0.  TDS 7.0+ works.  

I modified the test to make the problem somewhat clearer.  With 7.0, the
final query produces:

col              nrows       len         value     
---------------- ----------- ----------- ----------
nullable_char    11          NULL        NULL      
nullable_char    6           6           a char    
nullable_int     11          NULL        NULL      
nullable_int     6           4           1234      
nullable_varchar 11          NULL        NULL      
nullable_varchar 6           9           a varchar 

With 5.0: 

col              nrows       len         value     
---------------- ----------- ----------- ----------
nullable_char    1           NULL        NULL      
nullable_char    10          4                 
nullable_char    6           6           a char    
nullable_int     11          NULL        NULL      
nullable_int     6           4           1234      
nullable_varchar 1           NULL        NULL      
nullable_varchar 10          4                 
nullable_varchar 6           9           a varchar 

--jkl