FreeTDS Development Group

[James K. Lowden <jklowden AT speakeasy.org>]

On Sat, 9 Nov 2002 09:17:13 -0500, "tim" <thhoffman AT hotmail.com> wrote:
>   I've just installed freetds(0.60) on redhat 7.1, accessing sql2k on
>   win2k server. tsql works fine (selecting, inserting + updating), but
>   am having little luck with freebcp. I want to use freebcp because of
>   the amount of data to be loaded. Loading data into a table where
>   columns are defined as char, and using the -c option using tabs and
>   nls as delims works. I'm having no luck loading data where more
>   complex than char type data (ie: decimal or numeric) in the
>   definition. I assume the -f option on freebcp should be used in this
>   case (in conjunction with a format file). I've exported a format from
>   sql2k and brought it onto the linux box.

Confirmed, Tim.  

No, you don't need a format file, and no, you're not doing anything wrong.
 I just installed 0.60 myself, and found exactly the problem you describe:
freebcp mangles numeric types when uploading with TDS 7.0.  

Can you use a recent snapshot?  The problem has been fixed since the
release.  

--jkl