Hey ,

Alter native of UTF8 support in SQLSERVER 2008 R2

1. if u are importing multiligual file keep this in UTF16(UCS2[LE]) format rather than UTF8 because BCP import dont support UTF8 code page in MS SQLSERVER R2.

2.table where u importing multiligual character, column should be NVARCHAR type

Follow BCP Command for import data

bcp [DATABASE].[dbo].[tablename] in TestBCP.txt(UTF16 format) -S<SERVER> -U<USRName> -P<PWD> -C -w

option -w support widecharacter(after 256)

plz let me know if helps

thanks

Shashi