I want to read a SAP Table STXL which contains a RAW field and insert into a SQL Server table with type nvarchar.
The Schema suggested converting the RAW into byte but how can I convert this to nvarchar ?
Thank you in advance.
Hi Rhall_2_0 ,
Thanks for your input. When I tried adding what you've suggested , I get the error message "StandardCharSets cannot be resolved to a variable".
I enclose a picture of what I've attempted - is that what you meant ?
One Step further.... thank you.... but I still appears to me to be just raw data rather than the character text.
I can't help you without knowing more about the Raw data. It could just be the wrong character set that is being used in the conversion. I guessed UTF-8. Do you know the original character set? Do you know what the data should look like? Do you know if maybe it has been converted or encrypted? The first thing I would do is look for the correct character set or just try others out if you cannot get the character set.