Copying emojis in text from MySQL to SQL Server

35
October 25, 2019, at 4:40 PM

I am copying data from MySQL to SQL Server using a linked server.

SELECT comment FROM openquery(my_linked_server, 'SELECT comment FROM search_data');

The text in the MySQL table column is xxx

Answer 1

The Unicode codepoint of the character

READ ALSO
SQL: group by multiple limits

SQL: group by multiple limits

I have a simple table with id,key,level,table and data are something like this :

38