Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi,

We currently use the web Service function of SQL Anywhere with a Windows-1252 encoded Database (SQLA 17) and when we send a special character (like é, è, à), the Database do not convert it and add the scare character as a result in the Database. We tried from a browser and from C#, same result...

Any help is welcome.

Thanks

Here is the Message post :

POST https://iv-dev-sa17-1:444/software/Create_Notification HTTP/1.1
Authorization: Basic aXNvdmlzaW9uOmIxMGIxMGIxMA==
Content-Type: application/x-www-form-urlencoded; charset=utf-8
Host: iv-dev-sa17-1:444
Content-Length: 202
Expect: 100-continue
Connection: Keep-Alive
date=2021-07-12&hour=13%3A50%3A40&Description=Test+9+%C3%A9%C3%A0&Site_Code=03&Other_identifier=&Process_Activity=&Unit=&Component=&Observation_Pt=&Reported_By=&Serial_Num=&Work_Shift=&Numeric1=

asked 12 Jul '21, 15:59

webicool's gravatar image

webicool
26114
accept rate: 0%

edited 13 Jul '21, 05:13

Justin%20Willey's gravatar image

Justin Willey
7.6k137179249

Can you provide the definition of the webservice?

(13 Jul '21, 02:18) Frank Vestjens

Here it is :

CREATE SERVICE "Create_Notification" TYPE 'JSON' SECURE ON USER "user" AS select "sf_create_notification"(:date,:hour,:description,:site_code,:other_identifier,:process_activity,:unit,:component,:observation_pt,:reported_by,:serial_num,:work_shift,:numeric1) as "Notification_ID"
  from "dummy";

permanent link

answered 13 Jul '21, 08:04

webicool's gravatar image

webicool
26114
accept rate: 0%

edited 13 Jul '21, 09:10

Volker%20Barth's gravatar image

Volker Barth
40.3k363551822

2

Changing the TYPE 'JSON' to TYPE 'RAW' should do the trick

(13 Jul '21, 10:38) Frank Vestjens
Replies hidden

Thank you Frank, we'll try it and let you know.

(13 Jul '21, 12:28) webicool
1

Problem solved.

Thank you so much Franck !

(13 Jul '21, 14:50) webicool
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×66

question asked: 12 Jul '21, 15:59

question was seen: 1,231 times

last updated: 13 Jul '21, 14:50