IMPORT FROM CSV FILE & Non-UTF8 strings issue

[former_member540015]

Hi all!

What is recommended approach to load non-UTF8 (non European, non American) symbols into SAP HANA Express 2.0 database?

My CSV file is in Windows-1251 (Cyrillic) encoding, quite a big one (a few Gb) and I hadn't any issue with it in *.HDBTI routines, but when I've tried SDI I haven't found Win-1251 encoding in options.

Then I employed IMPORT FROM CSV FILE SQL command and have got weird invalid character encoding: '', /ce/c1/d9(ÎÁÙ).

So, what do you recommend, used to employ for non-UTF8 texts upload into HANA 2.0?

P.S. Please don't suggest SAP Vora yet, and yes, I'm practicing with Google BigQuery over ODBC.

P.S. 2 After format conversion from Windows-1251 to UTF-8 with the bash .sh script my file loaded successfully with IMPORT FROM CSV FILE SQL, but I wonder if this is only the way...

[JimmyYang]

I would suggest raising an incident with our SDI team. I did a search and I haven't been able to find any notes or existing cases where this was brought up. It could be a possible enhancement to SDI that is needed as well.

[former_member540015]

Thanks for the info Jimmy. Currently I'm concerned with the IMPORT FROM CSV FILE command constraints, so for me it's not an incident with the SDI team.