There is an error appearing during import of CSV file:
SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\x81fs to...' for column 'message' at row 1

Here is the CSV file being used: http://www.data.gov/download/92/csv

Only the first 352 rows seem to have imported properly.

Mappings are Title -> Title, Description -> Body, and URL -> GUID (unique).

Comments

TrevorG’s picture

TrevorG commented

Try opening your CSV in a text editor and saving it to a new file with UTF-8 encoding.

emorency’s picture

emorency commented

Great ! I had the same problem with a CSV file with accents and saving to UTF-8 solved the problem !

johnv’s picture

johnv
Primary language Dutch
commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.