August 18, 2009 at 2:21 am
Hi Friends,
Over the past years we were working with SQL Server 2000. We are importing very large text files using the BULK INSERT feature. We receive the text files UTF-8 encoded. With SQL Server 2000 we were able to import those files like this :
BULK INSERT T_TABLE_NAME
FROM 'E:\T_TABLE_NAME.TXT'
WITH (CODEPAGE = 65001, DATAFILETYPE = 'char', FIELDTERMINATOR = '|}', TABLOCK);
This was working perfectly fine. Now we are experimenting with an upGRADE to SQL Server 2008 and the same statement results in an error message.
Msg 2775, Level 16, State 13, Line 1
The code page 65001 is not supported by the server.
This is a showstopper for our conversion to SQL Server 2008. Is there a workaround to handle this?
Any suggestion would be appreciated , thanks in advance..
Mithun
August 18, 2009 at 12:31 pm
Apparently this is a known issue that currently will not be addressed in SQL Server 2008 but is supposed to be addressed in the next version of SQL Server. Here are 2 Connect items that refer to the problem:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=370419
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=321839
I'd recommend putting in another Connect item for this issue referencing the 2 above and then let everyone you know who uses SQL Server know about it so it gets voted up.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply