I have an AS400 Server (IBM i) for Linked Server to SQL, the problem is that some values (text type (varchar)) are not displayed correctly, something like this is seen in the result of the query by OpenQuery
0xD4C5C4C9C1404040404040404040404040404040
There is some way to convert this result to the Normal text, I tried the following but I do not get the expected result
declare @b varbinary(max)
set @b = 0xE3C5D4D7D9C1D5C1404040404040404040
select cast(@b as varchar(max))
Thanks for the help