http://www.perlmonks.org?node_id=718891


in reply to Re^4: Parsing MS SQL CSV export with Text::CSV_XS
in thread Parsing MS SQL CSV export with Text::CSV_XS

Your file appears to be in unicode format. The leading FEFF bytes are the byte order mark

You can probably save the file from SQL Server in a plain text format. If I remember correctly, output format ASCII txt will do this for some applications.

Alternatively, you can have Perl read and translate the unicode.

  • Comment on Re^5: Parsing MS SQL CSV export with Text::CSV_XS