Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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

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.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base