convert text with utf8 encoding to SQL SERVER using SSIS

I'm trying to find the best way to load a source table from MySQL (with the following column definition: text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL) into SQL SERVER using SSIS. SSIS automatically recommend "Image" data type. However it doesn't suit. Furthermore, in the "preview" dialog i get this data: "System.Byte[]". What's the best way to convert this column in to something more usable utilizing only SQL and MySQL transformations?

Answers


Convert to UTF-16 on MySQL. SQL Server NCHAR is UTF-16 so that should work straight away.


Need Your Help

Jtable Select row and columns

java swing jtable

I want to select a row and column of jtable's cell and print the value, i do this in public void changeValue(),as shown below, but i got this error:

Exchanging messages between UI Thread and Background Networking Thread

java android

I am currently working on an android app just for personal use. The app communicates with a server by TCP sockets. If the user makes an input it needs to be sent immediately. Also there can be mess...