SAP HANA

[mmishkin]

We recently purchased the SAP/HANA connector. Some tables work great but with others I get

ERROR: CLI cursor extended fetch error: [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10427 Conversion of parameter/column (20)

       from data type NVARCHAR to ASCII failed

I was able to pull a couple of examples on what data is being errored out on. One conatains a ',' and the other a '-' . Does anyone have an idea how to fix this?

[ballardw]

I would be tempted to look for unicode characters. ASCII only has 255 characters. Since the unicode sets exceed that then mapping can be an issue.

This is a guess. This is only a guess. I do not have access to SAP or similar.

[mmishkin]

That's what I think as well, how do you fix it though?