Skip to Content
0
Jun 02, 2018 at 03:09 PM

IMPORT FROM CSV FILE & Non-UTF8 strings issue

674 Views Last edit Jun 06, 2018 at 02:55 PM 3 rev

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...