[freetds] defncopy patch

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Mon Dec 3 11:24:59 EST 2007


> 
> Hi Frediano, 
> 
> I see you're doing a bit of Win32 and mingw hacking.  I have 
> a patch for
> defncopy you might like to use?  
> 
> I use our defncopy at work -- as patched -- but I haven't 
> committed it to
> CVS because it was a quick hack, much too nasty for general 
> consumption. 
> I don't have time to putz with Win32 FreeTDS stuff at work, 
> and at home I
> don't have a Win32 machine (or much energy for that side of 
> things).  But
> if you or someone else would like to make defncopy work out 
> of the box on
> Win32, I think that would make a fine Christmas present.  
> 
> One thing that isn't obvious about the problem domain: the stored
> procedure text in syscomments holds some surprises.  Some 
> utilities -- I
> think Microsoft's Query Analyzer, but I haven't looked into 
> it carefully
> -- use 0xOD as the line terminator.  Not 0D0A, not just 0A, 
> but a plain
> 0D.  When you write that via fopen "w", you get ODODOA.  Load 
> that back
> into the server, and the next time it's extracted in Query Analyzer,
> everything appears double-spaced.  Oh, the joys!  
> 
> Solve this locally, I put the SQL text though Perl (what else?): 
> 
> 	| perl -pe"s/\r+\n/\n/g; s/\r+/ /g;"
> 
> which works for me but it would be nice to solve correctly in 
> defncopy.  
> 
> BTW, I think I solved the bcp thing once and for all.  The 
> offset table
> wasn't just hard to read, it was wrong in the presence NULLs. 
>  More soon. 
> 
> 
> Happy Hacking.  
> 

Mmmm... I don't understand the intent of the patch. re you trying to
compile a program that use FreeTDS under Windows with Visual C++ or are
you trying to compile defncopy with Microsoft dblib? There are some
pieces that are generals others that I don't understand.

bye
  freddy77


More information about the FreeTDS mailing list