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