BCP fails to strip BOM from a UTF-16LE file when you use a format file - by Erland Sommarskog

Status : 


Sign in
to vote
ID 3105328 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 10/2/2016 11:17:26 AM
Access Restriction Public


If you load a Unicode file encoded in UTF-16LE and that has a BOM (byte-order-mark), BCP is able to load this file correctly, if you load it without a format file. However, when using a format file, BCP includes the BOM in the data for the first field, which leads to an incorrect load.

Note that this problem does not occur when loading UTF-8 files with a BOM; for these BCP handles the BOM correctly.
Sign in to post a comment.