I'm using PHP3, ODBC, Informix and Windows NT.
I have a major problem using ODBC access to an Informix database.
When using an update statement with long char data fields I get an error saying that a quoted string exceeds 255 characters. Is this a PHP limitation or an ODBC driver limitation?
So, to try and get around the problem, I decided to try and use a parametrised query using odbc_prepare and odbc_execute. I am hoping that the array of parameters passed to odbc_execute may not suffer from the 255 character restriction. However, this always gives me an error saying that the data has been truncated, even if the only parameter passed to odbc_execute is an integer!.
Does odbc_prepare/odbc_execute work at all? Or am I just using it incorrectly? Any help would be greatly appreciated.
I have a major problem using ODBC access to an Informix database.
When using an update statement with long char data fields I get an error saying that a quoted string exceeds 255 characters. Is this a PHP limitation or an ODBC driver limitation?
So, to try and get around the problem, I decided to try and use a parametrised query using odbc_prepare and odbc_execute. I am hoping that the array of parameters passed to odbc_execute may not suffer from the 255 character restriction. However, this always gives me an error saying that the data has been truncated, even if the only parameter passed to odbc_execute is an integer!.
Does odbc_prepare/odbc_execute work at all? Or am I just using it incorrectly? Any help would be greatly appreciated.