Not able to load data with writing script because of one specific field

[Lucius_Artorius_Castus]

Hi, I am using qlikcloud and i am loading the data via data editor, I am writing a script it is giving me an error

And this is the script

And i have debugged this query and the problem is description field, without that field i am successfully able to load it.
Description field contains these type of records (it is in varchar)

So please let me know how to handle this, It would be great if I can solve this problem quickly.

Regards,
Lucious

[jchx]

Try removing the space before the description field in the SQL select bit, does it help?

[vinieme12]

could be an issue with the connector, I'd suggest you raise a support ticket

[Lucius_Artorius_Castus]

Yes I tried But same error.

[Lucius_Artorius_Castus]

Yes if i directly upload csv qlik loading perfectly, I checked it is using a charset to convert it.

[Lucius_Artorius_Castus]

So I was able to solve this by encoding it to this charset (ENCODE(DESCRIPTION, 'ISO-8859-1') AS DESCRIPTION)

in source destination for now, and qlik sense is loading data successfully.
But sill it would be great if qlik is providing any function or script to encode by this charset.

[marcus_sommer]

That's not possible because the error isn't on the Qlik-side else comes from the data-base respectively the connector like stated in the error-message.