Special characters issue

[Former Member]

Hi,

In my raw data which is in .xls format, the Ascii of last character of the value “410100200640 “ is 160 (Ascii code 160 corresponds to  the value something  looks  like a’)

This excel file is converted into .csv file and this is uploaded in HANA (SPS 8). The datatype of the column which holds the value is “NVARCHAR”.

After running a sql query in HANA, for the same value, the Ascii is 239 (Ascii code 239 corresponds to the value something looks like ‘)

We want to understand

Why this is happening

How to upload the table containing special characters in to HANA without changing the original values

[muthuram_shanmugavel2]

Hi Srisha,

By Mentioning the File encoding method as "ISO-8859-1",

you can get the data in HANA Table as same format in Flat File.

please find the steps.

My Input Data in CSV:

In Flat File Import, We have the Option to choose the encoding method.

Choose File Encoding Method as "ISO-8859-1"

(Studio Version: 2.1.14)

Then Import the data.

I check My Table, I am getting the data in Original format only.

Best Regards,

Muthu