Fix encoding ’ [closed]

The reason commenting out (see q ) didn’t work is that the data was wrong in the database, so no encoding change could fix it.

I restored the database by copy pasting the sql script into PHPMyAdmin, and the text box interpreted the text as having the wrong encoding. By using import in phpmyadmin and selecting the file, that data came in correctly.

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. Apostrophes showing up as ΓÇÖ after converting from Windows to Linux
  11. WordPress content shows this character ​​
  12. Symbols such as £ end up being  in the database
  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 replace � in a string
  29. Does “\d” in regex mean a digit?
  30. What is base 64 encoding used for?
  31. Python – Reading and writing csv files with utf-8 encoding
  32. how to convert negative hexadecimal to decimal
  33. I have a string with “\u00a0”, and I need to replace it with “” str_replace fails
  34. “Unmappable character for encoding UTF-8” error
  35. Using unicode character u201c
  36. URL Encoding Issue %3D instead of (=)
  37. C# Encoding a text string with line breaks
  38. If a hacker changed the blog_charset to UTF-7 does that make WordPress vulnerable to further attacks?
  39. Character encoding issue after changing servers
  40. Add whitespace between Chinese and other letters
  41. WordPress Database Charset/Collate
  42. Why WP encodes UNICODE (UTF8) containing urls? Any drawbacks of UNICODE url?
  43. do_settings_sections() doesn’t escape quotes
  44. Allowing non-latin characters in registration
  45. JSON not valid after json_encode posts
  46. Non-Latin Characters in permalinks
  47. How to increase the character limit for post name of 200?
  48. Faulty restore of the database, encoding issue
  49. How to encode post content as JSON?
  50. WordPress load-scripts.php encoding issue
  51. Text cut off on save
  52. Custom DB_COLLATE (collation) value not working on fresh install?
  53. What is WordPress file encoding?
  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. Site Rss not seen by browser
  58. WordPress problem with htmlentities
  59. Emojis getting converted to “?”
  60. urlencode query string in gravity forms confirmation redirect
  61. HTML Entities displaying improperly as malformed escaped code
  62. Post Content, Special Characters and Filters
  63. How to get my post title to work with an apostrophe (‘s)?
  64. Editing URL character replacement
  65. Return encoded Page Title outside of a loop
  66. How to properly encode url with parameters for redirect_to
  67. Avoid glitchy characters – my own version of the problem
  68. Adding inline JavaScript encoding issue
  69. copying text from ms word to wordpress post appears weird [closed]
  70. Unicode characters displaying as ? after import using WP Clone
  71. How to use Japanese characters for a single page
  72. esc_js() breaks unicode sequences by removing the slash ‘\’ character
  73. Post editor loads empty
  74. UTF8 Encoding problems when exporting posts
  75. WordPress doesn’t display accents after migration
  76. Images are not showing after moving WordPress installation from server to localhost?
  77. Problems character encoding for pages in multiple languages
  78. Blank spaces show as a question mark
  79. Function to replace comment’s accented characters before posting
  80. Outputting HTML elements through WP-API
  81. WordPress site stopped working after simply opening header.php in the wp-admin editor
  82. Problem with UTF8. italian/russian characters
  83. How to automatically convert “%” and “+” in image urls on upload
  84. Problems with wierd characters and my plugin
  85. Special characters in post_title replaced by ‘?’
  86. Plugin won’t output characters with diacritics properly
  87. French accented text replaced with ? in woocommerce product list
  88. How to encode correclty an url with the char “&” for an email?
  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. All of my wordpress sites showing †Ù¥
  95. filter wptexturize doesn’t work on old posts titles
  96. Plugin error on activation – breaks page encoding and prints the code of plugin php files
  97. Admin encoding problem
  98. wp-login.php ampersand in url results in 404
  99. Multisite Â&nbsp wrong encoding problem
  100. WordPress v3.1 Has Character Encoding Issue With Title/Permalink?