I am working on an existing PHP code using an undocumented external homemade framework. The database used is Sql Server 2008.
The program gets an Excel file, parses it and saves the data into the database using PDO. I have no access to the server config, only the code. I can't change the database configuration (the text type can't turn into a VARCHAR type).
One of the values was stopping the execution,
- The error occurs just on the execute() command,
- I replaced the content by a same lenght "Lorem ipsum" (assuming an encoding error or anything else), still not working,
- I reduced the content lenght, it worked,
- I checked into the database to get the data type, it is a TEXT field,
- I played it again and again to know exactly the limit, this limit is 4000 characters,
I tried to execute the query on Sql Server (sample):
INSERT INTO [dbo].[database] (tableName, tableId, verifString, inErrorText, code, status)
VALUES ('DIAG', 123455, 'diag', '[Long string more than 5000 characters]', 'ABC023','anoma')
It worked
I tried the exactly same query [only changing the id] in PHP (sample):
$statement =$this->db->prepare("INSERT INTO [dbo].[database] (tableName, tableId, verifString, inErrorText, code, status)
VALUES ('DIAG', 123456, 'diag', '[Long string greater than 4000 characters]', 'ABC023','anoma')");
$statement->execute();
And again, the execution was stopped.
If I put a short string into the same query [only changing the id] (sample):
$statement =$this->db->prepare("INSERT INTO [dbo].[database] (tableName, tableId, verifString, inErrorText, code, status)
VALUES ('DIAG', 123457, 'diag', '[Short string lower than 4000 characters]', 'ABC023','anoma')");
$statement->execute();
It works
I searched if there were any restrictions in the homemade framework but I didn't find anything.
Any idea?
I hope my english is understandable. Thanks for your attention.
