How do you import UTF-8 flat files into SQL Server 2008 R2?
Not true, you simply need to choose code page 65001
- convert your data file to UTF-16 Little Endian (exactly Little Endian)
- use bcp with -w option.
Not true, you simply need to choose code page 65001