on 2024 Nov 07 1:49 PM
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
}
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
30 | |
10 | |
8 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.