Hi all,
I would like to ask how to convert text(string) to binary then save in DB. Since there is a input for user to enter a lot of wording (around 8000 ~ 9000 words), thus there is people suggest me to convert text to binary before save in DB.
Please suggest how I can do this, Thanks
Hi Jack,
There's an Action (TextToBinaryData) that should serve you in the BinaryData extension:
Whenever you need to display the value again, you can reverse it with BInaryDataToText.
Also, make sure that you store this in a seperate Entity, to avoid slow downs on querying.
Kilian Hekhuis wrote:
Thank you for your suggestion.
Hi All,I am using TextToBinary Action to save the response got from API in database, but some special characters like double quotes(“double quotes are copied from word”) are not getting saved correctly, but normal double quotes are getting saved correctly("normal double quotes") same scenario for single quotes, while saving the double quotes(“double quotes are copied from word”) from outsystems input widget, entering text manually it is getting saved correctly, but while saving from API it is not getting saved Properly.any suggestion how to save the response from API or How to display the data from DB to Outsystems would be great help,Thank you in advance
Hello Somali
You wake up from an old discussion from more than a year ago.
It would be better to start a new discussion. That way if in your case someone replies with a solution, then you can mark it as such.
Regards