Text field as400 are seen as varbinary in SQL SERVER

1

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

    
asked by Juan Andres Velazco 22.12.2017 в 17:54
source

0 answers