Niloo Niloo - 13 days ago 6
MySQL Question

MySQL TEXT column in load file

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?

Answer

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

Comments