Front page | perl.dbi.users |
Postings from March 2006
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
Thread Next