Loading Language dependent text to HANA

[former_member185403]

Hi,

I have an Excel File which contains Cross-Geo data which I need to load in SAP HANA.

It contains many fields, among them one description field contains some descriptions in Chinese Language.

Rest of all fields are in English.

When I load it to HANA using import method Flat File , it does not load data to HANA, but it shows invalid characters in HANA table (attached).

Can anybody suggest how to load the Descriptions in Chinese to SAP HANA using Flat File Load.

Thanks,

Krishnendu Roy.

[former_member194612]

Hi,,

Can you try blob datatype.

Thanks

Satish

[former_member185403]

Hi Satish,

I tried with column type NVARCHAR,BLOB,CLOB type, but it returns the same result....(my previous screenshot)

Thanks,

Krishnendu Roy.

[former_member182302]

Use NVARCHAR data type for that columns

Regards,

Krishna Tangudu

[former_member185403]

Hi,

I am already using NVARCHAR.

Regards,

Krishnendu Roy.

[former_member182302]

Can you Share the screenshot with the error message while loading?

Regards,

Krishna Tangudu