Hi I’ve just integrated our system with a review website, importing review scores and comments to store in our database.
This is done via a JSON API. The comments will often include emoticons and unfortunately these choke our MySQL implementation (MyConnect plugin) because (I think) it communicates using the utf8 charset, whilst MySQL requires utf8mb4 in order to store emojis. Attempting to execute a query containing those characters throws a MySQL error. I’m quite happy to get rid of the emojis, but I cannot see a way of stripping these from the text. I’ve tried using ST Get Plain text and JSON Stringify, without any luck. Does anyone know a way of stripping a text field so that it only contains regular (UTF8 compatible) characters? Or does anyone know a way of sending them through MyConnect? TIA James ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
