Assume that you use the BULK INSERT or the OPENROWSET(BULK...) statement to import UTF-8 encoded data from a file that doesn't have a byte-order mark (BOM) in Microsoft SQL Server 2016. If the first two bytes in the file are equal to "0xEFBB", the first character will be wrongly recognized as a BOM. As a result, the imported data is incorrect, and you don't receive an error message about it.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
문서 ID: 3172671 - 마지막 검토: 2016. 7. 25. - 수정: 1