Accentuation with multipart / form-data form and sql server using ajax

0

Hello. I have a problem that is making me sleepy. I am working on legacy code in classic asp and need to register a form that contains pdf file and data (like name, surname) and other fields. When the page is submitted to the server (iis8) via the form submit event, everything runs fine and the fields are saved in the sql with the accents correctly. However, some files are large and the page response may take a while, leaving the user unaware of what is happening. I started using ajax to do the submit and keep a progress bar. The problem is that the accent is not persisted correctly in the database. I have already checked the save.asp page in the firefox debug and the accent is correct. I made a response.write of the field values and everything is accented correctly. The two files (cadastro.asp and salv.asp) have the same encoding (Windows-1252). I've noticed that the "content-length" when posted by ajax has 24 bytes more than when posted only with the submit. How do I solve this situation? Has anyone had this? I'm using the jQuery Form Plugin component (malsup dot with jquery form) to submit the form via ajax.

Edit

It seems like this is an ADODB problem. I have tried several ways to submit the data to the database, all using ADODB (with command, recordset, etc). In all cases, when I use ajax (it does not matter the ajax plugin to do this - I tested it with pure ajax, jQuery Form Plugin and jQuery File Upload Plugin) ADODB encodes text that contains accented characters before sending to the database. But this only happens with a submit with ajax. When the submit is the default, nothing is encoded and everything goes well. To solve the problem, I used a function found here: link and everything is working as it should. To simplify the answer: The cadastro.asp file is saved in utf-8. The save.asp file is with the first line like this: and

asked by anonymous 09.10.2017 / 20:41

0 answers