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.2k361549822

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:

×64

question asked: 12 Jul '21, 15:59

question was seen: 1,184 times

last updated: 13 Jul '21, 14:50