We have to import UTF8 formated CSV data into a MS SQL 2008R2 DB table.
MS SQL don't support the codepage 65001.
Also the datafiletypes "widechar" and "widenative" stops with the error message that the first column is too long in the first line.
For convert the data file without lost information we try convert the file from UFT8 to UTF16, but UTF16 is not a known coding in .NET. Only UTF7, UTF8 and UTF32 are knowing codings.
What is good working solution for this problem?