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.

2 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, 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
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base