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

BULK INSERT cannot load UTF-8 files with a non-ASCII field terminator

You have a data file in UTF-8. The separator is outside the ASCII range. The file can be loaded with BCP. However. BULK INSERT does not seem to be able to handle the file.

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 →

    Upvotes: 2

    <=-=May 21 2017 3:20AM=-=>

    The docs (at msdn: “Specify Field and Row Terminators (SQL Server)”) say, “Any printable character”. They do not say, “Any printable ascii character”, so the product is not currently meeting this important promise.

    Although it’s well and good that the product supports “String of up to 10 printable characters”, and this could be used to specify a bullet-proof terminator signature, Excel does not support importing text files with multiple sequential delimiters, so generating files with such a sequence would not support viewing/manipulating the data in Excel. In practical terms, we end up needing to use standard qualifiers, which are ugly.

    There is value to supporting non-ascii field terminators so please fulfill the promise made in the docs.

    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