Hi all, I had a need to support [n]varchar(max) and varbinary(max) datatypes of MS SQL Server 2005, and patched DBD-ODBC. Below is the diff from the current svn.
Thanks, Fumiaki Yoshimatsu Index: C:/DBD-ODBC/dbdimp.c =================================================================== --- C:/DBD-ODBC/dbdimp.c (revision 3682) +++ C:/DBD-ODBC/dbdimp.c (working copy) @@ -1761,7 +1761,6 @@ /* patch to allow binary types 3/24/99 courtesy of Jon * Smirl */ - case SQL_VARBINARY: case SQL_BINARY: fbh->ftype = SQL_C_BINARY; break; @@ -1782,6 +1781,14 @@ fbh->ColDisplaySize = sizeof(TIMESTAMP_STRUCT); break; #endif + case SQL_VARBINARY: + fbh->ftype = SQL_C_BINARY; + case SQL_VARCHAR: + case SQL_WVARCHAR: + if (fbh->ColDef == 0) { + fbh->ColDisplaySize = DBIc_LongReadLen(imp_sth); + } + break; } /* make sure alignment is accounted for on all types, including