The Byte Order Marker of a text file isn't parsed correctly

Description

When reading a CSV file with CFHTTP that contains a Byte Order Marker is is not correctly parsed. This leads to very confusing error messages. If I upload a csv file with the following first row and including the BOM...

CSV File

Then on reading this file with CFHTTP with firstrowasheaders enabled it will throw the following error if I refer to the "title" column.

column [Title] not found in query, columns are [´╗┐TITLE,SUPPLIERREF,END PREORDER WINDOW,PRE-ORDERS]

Which is obviously confusing.

Environment

None

Status

Assignee

Unassigned

Reporter

Jay Smith

Labels

None

Fix versions

Affects versions

Priority

New
Configure