how to save string in HANA which contains percentage sign?

Question

I have an XSJS service where I'm saving some strings in a HANA table like

oEntity.save(new oEntity(oUploadedData))

It is working fine but if there is some special character in the string like % it fails. Is there any way to escape the percentage sign and save it like that?

Can you add your xsjs service code here - where you are getting this error?? — Sujith, Jul 24 '17 at 03:33
use **ALPHANUM** datatype to store special characters as mentioned in [this](https://archive.sap.com/discussions/thread/3556486) — boop_the_snoot, Jul 24 '17 at 12:00

score 0 · Accepted Answer · answered Nov 03 '17 at 14:01

I've found a solution. The problem was not the percentage sign but the way i've sent data from the client to the server. If you are sending JSON string to the backend which contains percentage sign HANA xsjs gives an internal server error. Instead of just JSON.stringify(data) you should use ecodeURIComponent(JSON.stringify(data))

how to save string in HANA which contains percentage sign?

1 Answers1