Data cut in mysql

Question

Data cut in mysql

Navigation

#1 by (2 votes)

1

I'm adding a small text to my database but the text is always cut, for example:

Company X acts in private security with the purpose of preventing and reducing property losses in a particular organization, as well as inhibiting any action against people's lives. Our service is personalized and we respect the particularity of each client, setting up an operational plan according to procedures and after vulnerability analysis.

What is stored in the database.

Hiperion acts in private security with the aim of preventing and reducing property losses in a particular organization, as well as inhibiting any action against people's lives. Our service is personalized and respected.

Does anyone know what might be the cause of this?

php mysql

asked by anonymous 12.08.2015 / 15:09

1 answer

Make a select in a varchar column as if it were SQL datetime Register only some data of a form C # Asp.net MVC 5

score 2 · Accepted Answer

This happens because the size of your column (probably a VARCHAR with size 255) is limiting the amount of characters that can be registered in the table.

To resolve this, change the column type to TEXT . Example:

ALTER TABLE nomedatabela MODIFY nomedacoluna TEXT;

Note: It is recommended to back up the table when executing frame-changing commands.