I can not insert simple text into mysql with column text [duplicate]

0

I'm not able to do a simple update to a table that contains a TEXT column. I put a simple Spanish text however the sql returns me error saying that line is too large. But it is a very small phrase. Here is the error code:

SQL query error: Edit

UPDATE ppplaw.sobre SET pol_gestao_esp = 'Para la continuidad de
la excelencia en la prestación de servicios jurídicos y de la
satisfacción de nuestros clientes, colocamos todos los esfuerzos'
WHERE sobre.id = 1 

MySQL Messages:

 #1118 - Row size too large. The maximum row size for the used table type,
 not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs
    
asked by anonymous 17.06.2014 / 13:51

1 answer

0

By showing the error, your column is typed as "table", which does not allow you to enter text. It gives show columns from _nomeTabela_ to see if the type arrived right.

Another alternative would be the collation of your table. If the text is in UTF-8, it has, in practice, 8 bytes in size, which is 4x more than ANSI-encoded text or Latin-1, MySQL standards.

    
17.06.2014 / 14:53