ODBC for ABAP error returning Non-ASCII characters

[ignacio_soriano73]

Hi,

have been trying out the ODBC for ABAP connector on ABAP Cloud Trial 2023SP00 on Linux.

Created a CDS view that exposes SBOOK. When retrieving the data I receive non-ASCII codes which result in errors in Excel and other ODBC consumers.

I tried changing the Charset property in odbc.ini but no change.

Any suggestion of why I am not receiving UTF-8 which I think is the default?

Cheers

Ignacio 

Ps: Tests with ODBCforABAP on Windows with Excel for data consumption. No errors.

Checked locale on Linux which is en_US.UTF-8

[ignacio_soriano73]

So did the same test from Windows 11 and Excel with ODBCforABAP and there I have no issue, data is returned properly.

[ignacio_soriano73]

Just provinding myself the solution to the topics I mentioned.

1). iusql cannot return non-ASCII characters as it never was meant to do so. See iusql code which converts unicode to ASCII (no matter which option you provide in .odbc.ini)

2). UseWChar=1 in the ODBC driver properties will return proper Unicode in your consuming app

Question can be closed.

Cheers