search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2.01k stars 494 forks source link

Corrupt JSON Response Text on Mac (Possible Text Encoding Problem) #288

Open ethanlowens opened 7 years ago

ethanlowens commented 7 years ago

I see that there were threads in 2015 tagged "utf-8-issues" but it's unclear whether they were ever resolved. (Apologies in advance, I'm an amateur and don't have a great understanding of text encoding.) I wanted to see if there have been any updates, or anyone has found any solutions for handling characters that get garbled on Macs.

Basically, here's my issue: Used on a PC, my program, which uses VBA-Web to interact with SurveyMonkey's API, works perfectly. However, on Macs, certain characters in JSON responses are getting garbled. For example: What should be an apostrophe is ,Äô on Mac An ñ becomes √± And sometimes, a space after a period becomes ¬†

If anyone has a solution for this it would be a great help. I so appreciate the work you have done putting VBA-Web together!!

timhall commented 7 years ago

Thanks for reporting this issue. Unfortunately, there are persistent UTF-8 issues with Mac support. It'll require a lot of deep work, but it's on the roadmap.

dakkerd commented 6 years ago

Would the above also apply when you're forced to use a : in the parsed URL. For a specific server I need a :, but when adding it as a parameter, it returns a %3A.

I have only two occurences where this happens, so would it be possible to replace the string with the appropriate characters?