Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4

    Unanswered: convert codepage 1252 to 65001 (UTF8)

    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?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Pat, Thank you for your answer. I'll try it tomorrow, when I'm back at the office.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •