Is there a good way of exporting SQL_Latin1_General_CP1_CI_AS data to a UTF-8 format

• Resender

  SSCertifiable

  Points: 7285

  More actions

  May 12, 2015 at 8:27 am

  #398445

  Well I got the question, I already know that it's not possible via a t-sql query

  But what would be a good way be to deliver data from sql server 2008 database to an unknown rdbms system in utf-8

• Almighty

  SSCommitted

  Points: 1731

  More actions

  May 13, 2015 at 1:02 am

  #1797450

  it might be helpful ...

  Use SSIS to get data in csv or flat file and this is pretty simple or u can use export option also

  Open the file in Notepad++ and click Encoding->Convert to UTF-8.

  (Do not click Encode in UTF-8 because it won't actually convert the characters.)

  Create a new file in Notepad++ -> Go to Encoding -> Encode in UTF-8 -> Copy-paste the contents -> save the file as .csv

  WINNERS NEVER QUIT AND QUITTERS NEVER WIN

  WINNERS NEVER QUIT AND QUITTERS NEVER WIN

  sqlserversdba.wordpress.com