Bulk insert not retaining special chars of UTF-8 Encoded txt file Sql Server 2008
SQL Server 2008 does not support UTF-8 natively prior to SQL Server 2019. 

So how can you import your data correctly?


Convert your data to UTF-16 prior to your insert
Upgrade to SQL Server 2014 (SP2) or above and take advantage of code page 65001 in the bulk insert statement as below

BULK INSERT #table

FROM  'C:\MyFile.csv'+ WITH 

( 
    CODEPAGE = '65001',
    FIELDTERMINATOR = ',',
    ROWTERMINATOR ='\n'
);

Since UTF-8 is an encoding style, not a collation, store the data as VARBINARY and decode it in the front-end rather than the database.