on 06-02-2018 4:09 PM
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...
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.