note 28835 added to function.odbc-fetch-into

From: Date: Sat, 25 Jan 2003 11:23:25 +0000
Subject: note 28835 added to function.odbc-fetch-into
Groups: php.notes 
Request: Send a blank email to php-notes+get-42723@lists.php.net to get a copy of this message
Problem w/ MSSQL 2000 (or 7 possibly)::::: Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index, SQL state S1002 in SQLGetData in ... http://bugs.php.net/bug.php?id=18514 The above error will be seen when calling @ODBC_RESULT_ALL() on a resultset that contains a field of type 'text' (MSSQL 2K). If you see this error in @ODBC_RESULT_ALL then surely @ODBC_FETCH_INTO() will return false when the resultset contains a field of type 'text' (MSSQL 2K) - causing headaches. WORKAROUND : change the field type to NTEXT (SQL 2K/7) - this is preferable in many cases (except DB storage space) since NTEXT is simply Unicode Text. I tried a workaround at http://www.phpbuilder.com/mail/php-db/2001071/0240.php but this didn't work. It appears PHP could benefit from an update to its ODBC libraries since 'text' and 'memo' fields are often used in Win32 environments... -- http://www.php.net/manual/en/function.odbc-fetch-into.php http://master.php.net/manage/user-notes.php?action=edit+28835 http://master.php.net/manage/user-notes.php?action=delete+28835 http://master.php.net/manage/user-notes.php?action=reject+28835

« previous php.notes (#42723) next »