Error importing CSV to phpMyAdmin

Explanation of the problem

Typically, text files with special characters need to be saved in utf-8 , so databases that store texts that also have special characters should be saved in the same format.

In this way I assume that your text file is in the ansi , where UTF-8 fully understands all the ANSI characters, but the reverse does not happen.

So whenever you try to read special characters and a text file in ANSI format using UTF-8 it gives error exactly where the special characters are and the file stops being read.

For this reason phpMyAdmin does not perform the import completely.

Solution

Convert the file type to UTF-8 (I recommend using Notepad ++ ) and then import normally.