I'm having a problem when text is being entered into a Textarea field from an Apple device with Smart Punctuation turned on. When Smart Punctuation is turned on, text with double quotes, single quotes and dashes looks like this once it's saved to the database and then displayed:
When Smart Punctuation is turned off, text with double quotes, single quotes and dashes looks fine once it's saved to the database and then displayed:
I've tried to do a REPLACE to replace the problem punctuation marks prior to inserting into the database with the following:
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(p_additional_complaint_details,CHR(147),'"'),CHR(148),'"'),CHR(145),''''),CHR(146),''''),CHR(150),'-'),CHR(151),'-'),CHR(132),'"'),CHR(130),'''')
But that hasn't helped. I may be checking for the wrong ASCII codes, but best I can tell, they are correct.
Does anyone have any ideas on how I can get around this problem?
I'm using APEX 19.2 with Universal Theme.