Skip to content

GTF-8 BOM issue #11

@JJones780

Description

@JJones780

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 )

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions