UTF8 problem sql server

Question

I have some utf8 data which I would like to bulk insert (sql server 2005). I am using the CODEPAGE 65001:

BULK INSERT #bla
FROM 'D:\bla.txt'  
WITH 
( 
    CODEPAGE=65001,
    FIELDTERMINATOR = '\t', 
    ROWTERMINATOR = '\n'
)

Unfortunatly strings like this:

Erdağı

end up being stored like this:

Erda??

Do I use the wrong code page? Is there anything else I can do?

Thanks.

Christian

Answer 1

According to this link, "SQL Server does not support code page 65001 (UTF-8 encoding)." At first, I thought this related only to 2008, but according to a Microsoft technical writer's response to a question on this link, "SQL Server never has supported code page 65001 (UTF-8 encoding)."