ID: 37877
Updated by: [EMAIL PROTECTED]
Reported By: jr at johnrule dot com
-Status: Open
+Status: Feedback
Bug Type: *Database Functions
Operating System: xp
PHP Version: 4.4.2
New Comment:
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc.
If possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.
Previous Comments:
------------------------------------------------------------------------
[2006-06-22 19:35:35] jr at johnrule dot com
Note:
This is not about 'retrieving' data, or limits for data fields, this is
about a limit in executing SQL statements directly through a
COM(ADODB.Connection) to an Access .mdb file.
Example:
INSERT INTO users (first_name, last_name, address, city, state, zip,
username, password) VALUES ('Jonathan', 'Macintyre the 3rd', '123456789
Somewhere in the United States', 'Idaho', 'ID', '12345-12345',
'jonathanmacintyrethe3rd','thisismypassword')
The above command will fail because it is greater than 255 chars.
The command below will succeed however, using the exact same type of
connection:
INSERT INTO users (fname, lname, address, city, state, zip) VALUES
('Jon', 'Mac', '123 US St.', 'Idaho', 'ID', '12345','jmac','1234')
Do you see what I mean? This is the same limitation imposed if you try
to create a module in Access with a 'RunSQL' command as the
parameter...the field is limited to 255 chars.
However, the first command greater than 255 chars will succeed if you
connect through an ODBC (DSN) connection. I am not sure whose
limitation this is at this point? Since php is making the connection
and call to both, I was guessing that this is a php problem.
------------------------------------------------------------------------
[2006-06-22 19:04:08] [EMAIL PROTECTED]
Duplicate of bug #37757.
------------------------------------------------------------------------
[2006-06-21 17:48:51] jr at johnrule dot com
Description:
------------
An 'INSERT' command with more than 255 characters will fail when using
COM and an ADODB.Connection (i.e. a direct connection to an access.mdb
file). However, the command will succeed if you connect through an ODBC
connection to the same file. This would prove that the limitation is not
a part of the file itself, but a part of the functionality of the
interface...wouldn't it?
I tested this on PHP 4 and 5 with the same results:
Apache 2
PHP (4 or 5)
Windows XP
Reproduce code:
---------------
Just try to do an 'INSERT' command with more than 255 characters in it.
It works on an Access.mdb file through a System DSN (ODBC) but it fails
when using COM and ADODB.Connection (i.e. a direct connection to the
file).
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37877&edit=1
