Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Importing UTF8 file to SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-11-12 : 08:01:21
Rekha writes "Hi,

I have a file in UTF8 format which i need to import to sql server but the problem is SQL expects the file to be in Unicode UTF16 or UCS-2 format.Is there any way which i can import this UTF8 data to the SQL?Will BCP handle this?

Regards
Rekha"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-11-12 : 08:10:59
I found this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;232580

But I have a feeling you've already read this. I don't suppose you can use a separate utility to convert the file to UTF-16?
Go to Top of Page
   

- Advertisement -