ID: 10073
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: ODBC related
PHP Version: 4.0.4pl1
Assigned To:
Comments:
i am unable to reproduce this in the latest cvs builds. your sample script executes
fine. please check the latest 4.0.5 RC or the latest CVS. if this is still valid
please re-open the bug (change it's status).
Previous Comments:
---------------------------------------------------------------------------
[2001-03-29 23:45:02] [EMAIL PROTECTED]
for some reason, in ms access and mdac_typ.exe 2.6 on winnt or win2k, if you try to
exec query that has operation on more than 1 text field, it returns huge field size
which prevents the script from executing.
ex.
$q="select firstName + ' ' + LastName from Students";
odbc_exec($c,$q);
// if you trace the odbc function calles:
call SQLColAttributes with <SQL_COLUMN_DISPLAY_SIZE>
returns
SQLColAttributes with return code 0 (SQL_SUCCESS)
SQLLEN * 0x0012F568 (2147483598)
so php_odbc.c in php4dll will assume that this field requires (2GB ) memory hence
exits with error.
It seems like it is an odbc bug but php engine should be aware and not exceed max size
limit(say 65k or be defined in the ini/conf file) for a field.
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10073&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
