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. HTML encoding issues – “” character showing up instead of ” “
  28. What character encoding is >?
  29. How to replace � in a string
  30. Does “\d” in regex mean a digit?
  31. What is base 64 encoding used for?
  32. Python – Reading and writing csv files with utf-8 encoding
  33. Where does this come from: -*- coding: utf-8 -*-
  34. python encoding utf-8
  35. The origin on why ‘%20’ is used as a space in URLs
  36. I have a string with “\u00a0”, and I need to replace it with “” str_replace fails
  37. “Unmappable character for encoding UTF-8” error
  38. URL Encoding Issue %3D instead of (=)
  39. Python decoding Unicode is not supported
  40. C# Encoding a text string with line breaks
  41. If a hacker changed the blog_charset to UTF-7 does that make WordPress vulnerable to further attacks?
  42. Encode text string being appended as query to URL [closed]
  43. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  44. Add whitespace between Chinese and other letters
  45. How can I stop TinyMCE from converting my HTML entities to characters?
  46. Why WP encodes UNICODE (UTF8) containing urls? Any drawbacks of UNICODE url?
  47. Non-Latin Characters in permalinks
  48. Faulty restore of the database, encoding issue
  49. Remove “Category Archives: title” at the top of a category page [duplicate]
  50. How to encode post content as JSON?
  51. How to write Hebrew characters?
  52. What is WordPress file encoding?
  53. How to diagnose and keep in check encoding issues?
  54. add_rewrite_rule not working for language specific characters
  55. Query string becomes encoded when a static page is used as homepage
  56. Text cut off after the character 𪇆 in TinyMCE
  57. Emojis getting converted to “?”
  58. How do I change database charset when using `wpdb`
  59. urlencode query string in gravity forms confirmation redirect
  60. How to get my post title to work with an apostrophe (‘s)?
  61. Non latin post slug truncate
  62. Is sanitize_title_with_dashes formatting function too liberal (in terms of accepted characters)?
  63. Editing URL character replacement
  64. Return encoded Page Title outside of a loop
  65. How to properly encode url with parameters for redirect_to
  66. Avoid glitchy characters – my own version of the problem
  67. Adding inline JavaScript encoding issue
  68. copying text from ms word to wordpress post appears weird [closed]
  69. How to use Japanese characters for a single page
  70. esc_js() breaks unicode sequences by removing the slash ‘\’ character
  71. Post editor loads empty
  72. UTF8 Encoding problems when exporting posts
  73. Images are not showing after moving WordPress installation from server to localhost?
  74. encoded search terms with %20
  75. Problems character encoding for pages in multiple languages
  76. Uploaded image with non-english characters is named incorrectly in upload folder
  77. Blank spaces show as a question mark
  78. Outputting HTML elements through WP-API
  79. Email Obfuscation: Is antispambot() Acceptable? [closed]
  80. Problems with wierd characters and my plugin
  81. ✓ Checkmark Character Encoding Issue In WordPress Editor
  82. How to Fix Mangled Thai Characters
  83. Special characters in post_title replaced by ‘?’
  84. Encode URL for WhatsApp “click to chat” without loosing accented characters
  85. WordPress Dutch characters encoding problem
  86. How Can I Concatenate A String With One Of My Custom Field Value Before Saving The Post?
  87. How are cookie values encoded?
  88. Rest API encoding of double quotes
  89. Character encoding issue – black diamond question marks on imported post excerpts
  90. Theme-based character encoding issue
  91. Strange special character/Latin characters
  92. Search terms in other language turns out to question mark and symbols
  93. Control character encode after using jquery autocomplete
  94. filter wptexturize doesn’t work on old posts titles
  95. TinyMCE HTML Encode Backslash
  96. Special characters showing in fallback font
  97. wp_insert_post and title not utf8 inserts with empty title?
  98. Non english charcters support for WP Customer Reviews
  99. Language selection for blog doesn’t exist?
  100. Modify WordPress to not replace + (plus) characters from URLs?