Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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.7k137179252

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.5k365556827

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,353 times

last updated: 13 Jul '21, 14:50