UNHEX XML data from MySQL in SQL server

Question

I have selected XML data (TEXT column type) from MySQL using:

SELECT HEX(CONVERT(column USING utf16le)) FROM table

How can I get data back to XML in SQL server (now stored in NVARCHAR field)?

When downvoting, explain your reason. This question is related to stackoverflow.com/questions/36082433/… — Xdg
– Xdg, Commented Mar 11, 2019 at 9:15

Xdg · Accepted Answer · 2019-03-11 09:27:37Z

0

Right answer is to use this in SQL server:

CAST(
CONVERT(varbinary(MAX), column, 2) 
as nvarchar(max))

answered Mar 11, 2019 at 9:27

Xdg

1,8353 gold badges30 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1