0

I obtain this error when I try to insert a text that is approx. 85K long in a blob field.

I tried also to change the field to longblob ant to turn off strict mode, but with no result.

Thanks for your answer

Zeno
  • 55
  • 9

2 Answers2

0

try change the column type to text in de BBDD

Cristian Programador
  • 51
  • 4
0

Can you change the data type into LONGTEXT and then try again

Rajesh Murugan
  • 159
  • 15
  • Done with no positive result. The strange thing is that, if I cut & paste the text directly in the field, I have no problem. I fill the table with a PHP routine and a mysql_real_escape_string() command – Zeno Jul 06 '17 at 16:52
  • Are you pasting directly in the database? – Rajesh Murugan Jul 06 '17 at 17:08
  • Yes, I paste it directly into the field using MySQLYog that is a Win MySQL administration tool. – Zeno Jul 07 '17 at 13:34