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.


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.


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

asked 12 Jul '21, 15:59

webicool's gravatar image

accept rate: 0%

edited 13 Jul '21, 05:13

Justin%20Willey's gravatar image

Justin Willey

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

accept rate: 0%

edited 13 Jul '21, 09:10

Volker%20Barth's gravatar image

Volker Barth


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

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 12 Jul '21, 15:59

question was seen: 1,231 times

last updated: 13 Jul '21, 14:50