MySQL TEXT column in load file

Question

I have a table with some TEXT columns, all of them get value when I load the file into the table but the TEXT column with 100 length character does not work and shows null value. The source file is fixed width file and I have checked the character number and the proper length of the field.

Do I need to do any configuration to get a long TEXT field in the column?

https://stackoverflow.com/questions/13932750/tinytext-text-mediumtext-and-longtext-maximum-storage-sizes - Check this answer. — Radu Maftei, Nov 16 '16 at 08:11
It is 100 character and it is just simple load file sql every thing is working but this TEXT column with 100 character — Niloo, Nov 16 '16 at 08:22

score 0 · Accepted Answer · answered Nov 16 '16 at 15:34

Try to check the encodings/character sets.
If the text file is e.g. utf-8 and your text column ist e.g. latin1 a 100 char text from the file may need more than 100 chars in the database table.

In this case you need to change the encoding or the length of the text column.

See also: http://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html

MySQL TEXT column in load file

1 Answers1