phpMyAdmin，导入csv时文本被截断

Question

I import a csv file into myphpamdin. I have a column conatining text. The import is going fine and everything is getting updated beside the text which get cut off in the middle.

Table example:

"first_name" "last_name" "person_details"

"John" "Smith" "some long text that getting cut in the middle"

I tried to set the "person_details" to LONGTEXT but the "some long text" still getting cut in the middle.

Answer 1

some long text must have , , \t between it echo the long text and see it its source ode and you will find the cause

(in firefox righht click-> view page source) do not use firebug or something similar they are the smart tools they interpret these characters according to them