CAP: CESU-8 encoding

[viren_chawda]

I'm pulling some data from an API and trying to push update it into a table (cds entity) using CAP. In general everything is working as expected. 

But when I received few records in my data that have a different language (Cantonese in my case), then I get the below error while trying to update the table.

[SqlError: fatal error: invalid CESU-8 encoding for Unicode string] {
code: 3,
sqlState: 'HY000',
level: 1,
position: 0,
query: false
}

[catano]

Hi @viren_chawda ,

Could you describe the scenario in more detail? E.g.:

• Could you share an example request you try to send?
• Are you invoking an endpoint of your service?
  • Is it an action or a CREATE event maybe?
  • Do you have any custom actions attached to it?

Regards,
Peter

[viren_chawda]

Hi Peter,

After few more tests, I found the cause of the problem. Turns out its not the language that was causing the issue. Rather there was a an emoticon "😊" somewhere in the text of the data that was received from the API.

Once it was removed the data was loaded to the table.

Thanks,

Viren 

[catano]

Hi, I'm glad you made it work finally. Next time you might consider the rubber duck debugging method 😉 Best, Peter