Bug with apostrophe author name

Ok,

After few research I found an answer to my question why an author with apostrophe like John O’Smith for example doesn’t appear and seems to break the javascript code.
None of the solutions here are working. Can someone direct me how to remove the apostrophe from the database?

Many thanks,

https://www.ads-software.com/plugins/google-analytics-for-wordpress/