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

Reply via email to