SQL Server 2008 does not support code page 65001 for UTF8 encoding when importing text file.
- by Gothiclolita
It seems like SQL Server 2008 does not support code page 65001 when using Bulk Insert. If I use other code pages, my data is corrupted when imported. Is there a way to insert my UTF8 data properly in SQL Server 2008 using scripts?