in reply to Re: FreeTDS (Linux) vs. SQLSRV32.dll (Windows) via ODBC
in thread FreeTDS (Linux) vs. SQLSRV32.dll (Windows) via ODBC

Also, watch out for NULL (\0) characters at the end of strings returned from your queries. We started seeing that come out of DBI::ODBC + FreeTDS when we moved up to SQL Server 2005.

Did you do anything about this? Did you investigate it? If you still see this problem I would like to hear about it.

  • Comment on Re^2: FreeTDS (Linux) vs. SQLSRV32.dll (Windows) via ODBC

Replies are listed 'Best First'.
Re^3: FreeTDS (Linux) vs. SQLSRV32.dll (Windows) via ODBC
by coldguy (Sexton) on Jun 01, 2010 at 22:16 UTC
    Did you do anything about this? Did you investigate it? If you still see this problem I would like to hear about it.
    We didn't do anything about it other than s/\0$// -- it was an "Oh crap, we replaced the dead server and now the app is broke" kind of situation so I did a quick fix and never got back around to digging into the problem. I'm no longer at that position or working with MS SQL Server so I can't really tell you how it stands now.