I am doing an import from TSV (Tools -> Import CSV file), then in the file open dialog, selecting All files (.) with either ANSI or UTF-8 encoding (both generate the same error). When I select the Destination and a New Table, HeidiSQL scans all the rows from the file, but then abends at the end while analyzing the data.
Any ideas what I can to get around this problem? I tried several different encodings, including Unicode (does not detect any columns) and Auto Detect (same error as UTF-8).
I have successfully imported a different TSV already (title.ratings.tsv, 1.2 million rows, but only 3 columns). I used ANSI encoding just fine. I would speculate that the source character set is causing an issue. I downloaded the public dataset from IMDB, and the one the causing the issue is title.principals.