Apostrophes showing up as ΓÇÖ after converting from Windows to Linux

It looks to me like you’re not using an actual apostrophe, but one of the curly apostrophes, such as those that Microsoft Word might be configured to auto-correct to. There is a chance that your mysqldump was actually exporting it incorrectly. In my test database, both PowerShell and Command Prompt were dumping as ΓÇÖ, whereas Cygwin was dumping as ’. If your export does look fine in those areas, you may want to check the Content-Type return header to see that it is specifying UTF-8. If both of those check out, it could be that the database’s encoding needs to be modified.

As an alternative, you could replace any occurrence of ’ with '.

Related Posts:

  1. Is ‘# -*- coding: utf-8 -*-‘ also a comment in Python?
  2. What is the difference between UTF-8 and Unicode?
  3. Byte and char conversion in Java
  4. What is “=C2=A0” in MIME encoded, quoted-printable text?
  5. Strange characters – despite everything being UTF-8
  6. One for the gurus: upgrade to 3.x messed up only filenames with accented chars
  7. Word press replacing unicode characters with “?”s
  8. How to set charset for wp_remote_post request?
  9. Outputting post title without encoding
  10. WordPress content shows this character ​​
  11. Symbols such as £ end up being  in the database
  12. Fix encoding ’ [closed]
  13. Getting Non-printable characters were found while entering Euro Symbol
  14. How to deal with apostrophes
  15. Question mark on special chars
  16. Encoding Issue while using French in WordPress
  17. Get ?? for unicode characters
  18. WordPress theme character encoding issue
  19. character encoding problem in custom template
  20. restored old database now some characters have changed?
  21. WordPress plugin problem with encoding
  22. Post removes any text from post that’s following special characters
  23. UTF-8 Characters in URL – IE problem
  24. WordPress Dashboard Characters Messed Up
  25. How to make sure the letters ‘pez’ do not convert to a fish symbol? [closed]
  26. Problem some Persian texts show in ISO-8859-5
  27. What character encoding is >?
  28. how to convert negative hexadecimal to decimal
  29. “Unmappable character for encoding UTF-8” error
  30. Using unicode character u201c
  31. URL Encoding Issue %3D instead of (=)
  32. If a hacker changed the blog_charset to UTF-7 does that make WordPress vulnerable to further attacks?
  33. Character encoding issue after changing servers
  34. Add whitespace between Chinese and other letters
  35. WordPress Database Charset/Collate
  36. Why WP encodes UNICODE (UTF8) containing urls? Any drawbacks of UNICODE url?
  37. do_settings_sections() doesn’t escape quotes
  38. Allowing non-latin characters in registration
  39. JSON not valid after json_encode posts
  40. Non-Latin Characters in permalinks
  41. How to increase the character limit for post name of 200?
  42. Faulty restore of the database, encoding issue
  43. How to encode post content as JSON?
  44. What is wp_check_invalid_utf8?
  45. WordPress load-scripts.php encoding issue
  46. Text cut off on save
  47. Custom DB_COLLATE (collation) value not working on fresh install?
  48. What is WordPress file encoding?
  49. Query string becomes encoded when a static page is used as homepage
  50. Site Rss not seen by browser
  51. WordPress problem with htmlentities
  52. Emojis getting converted to “?”
  53. Unexpected = (equal sign) characters in wp mail
  54. Website dumps encoded result
  55. Why does wp_redirect strip out %0A (url encoded new line character) and how do I make it stop?
  56. HTML Entities displaying improperly as malformed escaped code
  57. Post Content, Special Characters and Filters
  58. Editing URL character replacement
  59. Return encoded Page Title outside of a loop
  60. How to properly encode url with parameters for redirect_to
  61. Avoid glitchy characters – my own version of the problem
  62. Adding inline JavaScript encoding issue
  63. copying text from ms word to wordpress post appears weird [closed]
  64. images not showing after transfer
  65. Unicode characters displaying as ? after import using WP Clone
  66. Post editor loads empty
  67. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  68. Special Character Appearing in my WordPress Pages Content
  69. encoded search terms with %20
  70. UTF-32be error WordPress
  71. How to distinguish between a hack and an encoding error?
  72. Uploaded image with non-english characters is named incorrectly in upload folder
  73. wp_mail encode ’ in ’ in subject
  74. Email Obfuscation: Is antispambot() Acceptable? [closed]
  75. WordPress site stopped working after simply opening header.php in the wp-admin editor
  76. ✓ Checkmark Character Encoding Issue In WordPress Editor
  77. How to Fix Mangled Thai Characters
  78. Encode URL for WhatsApp “click to chat” without loosing accented characters
  79. Encoding matter – ? instead of € after settings field callback
  80. Issue with json decode in WordPress – value is not returning consistently
  81. WordPress Dutch characters encoding problem
  82. Encoding video without exec function
  83. How Can I Concatenate A String With One Of My Custom Field Value Before Saving The Post?
  84. How are cookie values encoded?
  85. How to encode correclty an url with the char “&” for an email?
  86. Rest API encoding of double quotes
  87. How can I automatically add a post with Latin characters?
  88. Migrating a WordPress site has broken UTF8 encoding
  89. All of my wordpress sites showing †Ù¥
  90. TinyMCE HTML Encode Backslash
  91. wp-login.php ampersand in url results in 404
  92. Special characters showing in fallback font
  93. WordPress Database Charset/Collate
  94. How to pass post title (which could include &) to Gravity Form
  95. wp_insert_post and title not utf8 inserts with empty title?
  96. Non english charcters support for WP Customer Reviews
  97. Language selection for blog doesn’t exist?
  98. Modify WordPress to not replace + (plus) characters from URLs?
  99. js code not stored in database currectly
  100. WordPress v3.1 Has Character Encoding Issue With Title/Permalink?