cancel
Showing results for 
Search instead for 
Did you mean: 

Loading Korea Characters from Flat file into HANA through DS Job

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member187605
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Hi,

Data from Flat file to first Template table loaded properly Including 3 Korean Columns.

After transforming logic on English Columns, 3 Korean Columns are being populated as ####.

Regards.

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

krishnamohan_corp9
Participant
0 Kudos

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

Former Member
0 Kudos

Hi,

We have a source file saved as UTF-8.

We have enabled USE NVARCHAR for VARCHAR columns in supported data bases to YES for all tables (Permanent Tables, Template Tables)

Some times Korean Columns loading properly , some times not.

Regards.

former_member198401
Active Contributor
0 Kudos

Can you try using the UTF-16

Regards

Arun Sasi