gtfs_SQL_importer fails on importing utf-8 with BOM files.
The GTFS specification states utf-8 BOM is ok.
Files coming from a Microsoft environment are likely to have UTF8 w/ BOM.
Workaround: add a command to clean the BOM from the gtfs files before running the script.
LANG=C LC_ALL=C sed -e 's/\r$// ; 1 s/^\xef\xbb\xbf//' -i -- path/to/gtfs_files/*
(from https://unix.stackexchange.com/questions/381230/how-can-i-remove-the-bom-from-a-utf-8-file )
gtfs_SQL_importer fails on importing utf-8 with BOM files.
The GTFS specification states utf-8 BOM is ok.
Files coming from a Microsoft environment are likely to have UTF8 w/ BOM.
Workaround: add a command to clean the BOM from the gtfs files before running the script.
LANG=C LC_ALL=C sed -e 's/\r$// ; 1 s/^\xef\xbb\xbf//' -i -- path/to/gtfs_files/*
(from https://unix.stackexchange.com/questions/381230/how-can-i-remove-the-bom-from-a-utf-8-file )