From:             [EMAIL PROTECTED]
Operating system: windowsNT/2k
PHP version:      4.0.4pl1
PHP Bug Type:     ODBC related
Bug description:  ODBC MS ACCESS and  field size

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.

$q="select firstName + ' ' + LastName from Students";

// if you trace the odbc function calles:
call SQLColAttributes with <SQL_COLUMN_DISPLAY_SIZE>
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.

Edit Bug report at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to