? blob_patch
Index: php_odbc.c
===================================================================
RCS file: /repository/php-src/ext/odbc/php_odbc.c,v
retrieving revision 1.170
diff -u -u -r1.170 php_odbc.c
--- php_odbc.c	12 Aug 2003 00:55:56 -0000	1.170
+++ php_odbc.c	18 Aug 2003 13:06:15 -0000
@@ -460,6 +460,7 @@
 	REGISTER_LONG_CONSTANT("SQL_CHAR", SQL_CHAR, CONST_PERSISTENT | CONST_CS);
 	REGISTER_LONG_CONSTANT("SQL_VARCHAR", SQL_VARCHAR, CONST_PERSISTENT | CONST_CS);
 	REGISTER_LONG_CONSTANT("SQL_LONGVARCHAR", SQL_LONGVARCHAR, CONST_PERSISTENT | CONST_CS);
+	REGISTER_LONG_CONSTANT("SQL_BLOB", SQL_LONGVARBINARY, CONST_PERSISTENT | CONST_CS);
 	REGISTER_LONG_CONSTANT("SQL_DECIMAL", SQL_DECIMAL, CONST_PERSISTENT | CONST_CS);
 	REGISTER_LONG_CONSTANT("SQL_NUMERIC", SQL_NUMERIC, CONST_PERSISTENT | CONST_CS);
 	REGISTER_LONG_CONSTANT("SQL_BIT", SQL_BIT, CONST_PERSISTENT | CONST_CS);
@@ -653,6 +654,7 @@
 			case SQL_BINARY:
 			case SQL_VARBINARY:
 			case SQL_LONGVARBINARY:
+			case SQL_BLOB:
 			case SQL_LONGVARCHAR:
 				result->values[i].value = NULL;
 				break;
@@ -667,7 +669,7 @@
 			default:
 				rc = SQLColAttributes(result->stmt, (UWORD)(i+1), SQL_COLUMN_DISPLAY_SIZE,
 									NULL, 0, NULL, &displaysize);
-				displaysize = displaysize <= result->longreadlen ? displaysize : 
+				displaysize = displaysize <= result->longreadlen ? displaysize :
 								result->longreadlen;
 				result->values[i].value = (char *)emalloc(displaysize + 1);
 				rc = SQLBindCol(result->stmt, (UWORD)(i+1), SQL_C_CHAR, result->values[i].value,
@@ -1417,7 +1419,19 @@
 					Z_STRVAL_P(tmp) = empty_string;
 					break;
 				}
-				if (result->binmode == 1) sql_c_type = SQL_C_BINARY;
+
+				if (result->binmode == 1) {
+					sql_c_type = SQL_C_BINARY;
+				}
+			case SQL_BLOB:
+				if (result->binmode <= 0) {
+					Z_STRVAL_P(tmp) = empty_string;
+					break;
+				}
+
+				if (result->binmode == 1) {
+					sql_c_type = SQL_C_BINARY;
+				}
 			case SQL_LONGVARCHAR:
 				if (IS_SQL_LONG(result->values[i].coltype) && result->longreadlen <= 0) {
 					Z_STRVAL_P(tmp) = empty_string;
@@ -1571,7 +1585,19 @@
 					Z_STRVAL_P(tmp) = empty_string;
 					break;
 				}
-				if (result->binmode == 1) sql_c_type = SQL_C_BINARY; 
+
+				if (result->binmode == 1) {
+					sql_c_type = SQL_C_BINARY; 
+				}
+			case SQL_BLOB:
+				if (result->binmode <= 0) {
+					Z_STRVAL_P(tmp) = empty_string;
+					break;
+				}
+
+				if (result->binmode == 1) {
+					sql_c_type = SQL_C_BINARY;
+				}
 			case SQL_LONGVARCHAR:
 				if (IS_SQL_LONG(result->values[i].coltype) && result->longreadlen <= 0) {
 					Z_STRVAL_P(tmp) = empty_string;
@@ -1789,8 +1815,15 @@
 		case SQL_BINARY:
 		case SQL_VARBINARY:
 		case SQL_LONGVARBINARY:
-			if (result->binmode <= 1) sql_c_type = SQL_C_BINARY;
-			if (result->binmode <= 0) break; 
+			if (result->binmode <= 1) 
+				sql_c_type = SQL_C_BINARY;
+			if (result->binmode <= 0) 
+				break; 
+		case SQL_BLOB:
+			if (result->binmode <= 1) 
+				sql_c_type = SQL_C_BINARY;
+			if (result->binmode <= 0) 
+				break;
 		case SQL_LONGVARCHAR:
 			if (IS_SQL_LONG(result->values[field_ind].coltype)) {
 			   if (result->longreadlen <= 0) 
@@ -1947,7 +1980,15 @@
 						php_printf("<td>Not printable</td>");
 						break;
 					}
-					if (result->binmode <= 1) sql_c_type = SQL_C_BINARY; 
+					if (result->binmode <= 1) 
+						sql_c_type = SQL_C_BINARY; 
+				case SQL_BLOB:
+					if (result->binmode <= 0) {
+						php_printf("<td>Not printable</td>");
+						break;
+					}
+					if (result->binmode <= 1) 
+						sql_c_type = SQL_C_BINARY; 
 				case SQL_LONGVARCHAR:
 					if (IS_SQL_LONG(result->values[i].coltype) && 
 						result->longreadlen <= 0) {
@@ -2106,7 +2147,7 @@
 
 		if (direct) {
 			rc = SQLDriverConnect((*conn)->hdbc, NULL, ldb, strlen(ldb), dsnbuf, 
-					              sizeof(dsnbuf) - 1, &dsnbuflen, SQL_DRIVER_NOPROMPT);
+                                  sizeof(dsnbuf) - 1, &dsnbuflen, SQL_DRIVER_NOPROMPT);
 		} else {
 			rc = SQLConnect((*conn)->hdbc, db, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS);
 		}
Index: php_odbc_includes.h
===================================================================
RCS file: /repository/php-src/ext/odbc/php_odbc_includes.h,v
retrieving revision 1.6
diff -u -u -r1.6 php_odbc_includes.h
--- php_odbc_includes.h	14 Jul 2003 16:11:38 -0000	1.6
+++ php_odbc_includes.h	18 Aug 2003 13:06:15 -0000
@@ -266,8 +266,8 @@
 
 void odbc_sql_error(ODBC_SQL_ERROR_PARAMS);
 
-#define IS_SQL_LONG(x) (x == SQL_LONGVARBINARY || x == SQL_LONGVARCHAR)
-#define IS_SQL_BINARY(x) (x == SQL_BINARY || x == SQL_VARBINARY || x == SQL_LONGVARBINARY)
+#ifndef SQL_BLOB
+#define SQL_BLOB SQL_LONGVARBINARY
+#endif /* SQL_BLOB */
+#define IS_SQL_LONG(x) (x == SQL_LONGVARBINARY || x == SQL_LONGVARCHAR || x == SQL_BLOB)
+#define IS_SQL_BINARY(x) (x == SQL_BINARY || x == SQL_VARBINARY || x == SQL_LONGVARBINARY || x == SQL_BLOB)
 
 #ifdef ZTS
 # define ODBCG(v) TSRMG(odbc_globals_id, php_odbc_globals *, v)