on 10-27-2015 5:37 AM
Hi All,
I have Flat file as Input. This Flat File Contains 10 Columns with Pipe Delimiter.
Out of 10 Columns, 3 columns are Korean Language Characters. While loading data from Flat file to HANA Table through DS Job, Instead of Korean characters, ##### are being stored in Table.
Could you please help me how to load Korean characters properly?.
Regards.
You've got to make sure that code pages for source file, DS and target database all support Korean characters.
For DS and HANA, that shouldn't be a problem, they do by default. But check that the code page in the flat file properties is set to utf-8, not default.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The Data Store which stores the Template Tables has not been configured for UTF-8.
I changed to UTF-8 and now data is loading good.
Thank You all for your Inputs.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chaitanya,
Please convert the code page for source flat file as UTF8 & also in target file please set the below option to YES...
(USE NVARCHAR for VARCHAR columns in supported databases to YES).
Regards
Krishna Mohan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.