Characters in import

Hi

I’m downloading data from a SAP table… (suppliers)
I’m getting, for instance, “CÔmara ComÚr.e Ind·str.da Made”

Is there a way to convert in EasyMorph?

Thanks

Hugo M.

Hi Hugo,

And what is the actual\expected string?

Hi
“CÔmara ComÚr.e Ind·str.da Made” shoud appear "Câmara Comér.e Indústr.da Made”
Tried with “COLLATE” in the select and it doesn’t work…
Thanks

Hugo M.

Hugo, were you able to import that string correctly with the same ODBC DSN in other applications?

And which type the corresponding column has? It seems that similar issue may appear when Unicode strings are stored in VARCHAR column instead of NVARCHAR.

Hi

Managed to export using SQL Management Studio …

Thanks

Hugo