Mac, I’ve just checked an export on my own machine and don’t see anything like that. So I can only guess at the possible causes on yours:
It could be a “mac” thing. I use PC and don’t see this problem.
It could be something in the settings of yoor FTP software. I’ve never heard of “transmit” so can’t help with that I’m afraid.
It coulld be something to do with the encoding of your database (normally “itf8_general_ci” Your web host might be able to comment on that.
I’m afraid I can’t advise on the use of “Zap Gremlins” either. I’ve never heard of that nor do I have any experience of Text Wrangler either. Presumably its a mac text editor? I do not however recommend the use of anything you don’t understand. get some advise from someone who understands and uses those products.
MySQL connection collation is: utf8_unicode_ci. Yes, all my stuff is Mac. Transmit is a FTP client. Text Wrangler is free version of a program called BBEdit – text editor but has the line numbers and helpful stuff for HTML coding. Saves clean text. Will keep an eye on file. Copy I saved offline I “zapped”, usually cleans stuff up.
PS: I put my setup info in my profile notes as I don’t see a signature line. But my beer penguin is back 🙂
----- [updated: 31Aug2023]
Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 - PHP Version 8.1.17 - mySQL 8.1 The Royals |The Kennedys|The Gerrer Rabbis 3.3.12 - PHP Version 8.1.17 - mySQL 8.1