convert codepage 1252 to 65001 (UTF8)

Wim · #1 (**permalink**) 02-02-12, 11:26

Hi,

I am trying to export the data from a number of MSSQL 2000 tables to UTF8 csv files.

Using the bcp that came with MSSQL 2000 didn't work (UTF8 related), so I am now accessing the 2000 database from within MSSQL 2008 R2 Management Studio and use its Import and Export wizard that does make UTF8 exports possible.

But it fails. This is the error I got for one table.

Code:

- Validating (Error)
Messages
Error 0xc00470d4: Data Flow Task 1: The code page on input column "cmsGUID" (74) is 1252 and is required to be 65001.
 (SQL Server Import and Export Wizard)
 
Error 0xc00470d4: Data Flow Task 1: The code page on input column "PublicationStatus" (79) is 1252 and is required to be 65001.
 (SQL Server Import and Export Wizard)
 
....

What do I have to do?

Pat Phelan · #2 (**permalink**) 02-02-12, 11:57

I would use the BCP that ships with SQL Server 2008 R2 to move the data from the SQL 2000 server to the UTF-8 encoded CSV file. The problem you're encountering lies in the code of the SQL 2000 version of BCP.EXE, not in your data or the process that you're following.

-PatP

Wim · #3 (**permalink**) 02-02-12, 16:08

Pat, Thank you for your answer. I'll try it tomorrow, when I'm back at the office.

Internet Services

Web Development

Digital Marketing

Consumer Tech