restored old database now some characters have changed?

ok! seems to have it fixed only by
choosing Character set of the file latin1
while importing backed up database

something mentioned by @chris-o

here
Faulty restore of the database, encoding issue

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. Fix encoding ’ [closed]
  14. Getting Non-printable characters were found while entering Euro Symbol
  15. How to deal with apostrophes
  16. Question mark on special chars
  17. Encoding Issue while using French in WordPress
  18. Get ?? for unicode characters
  19. WordPress theme character encoding issue
  20. character encoding problem in custom template
  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. hashlib.md5() TypeError: Unicode-objects must be encoded before hashing
  29. Converting string to byte array in C#
  30. how to convert negative hexadecimal to decimal
  31. Using unicode character u201c
  32. Random Question Mark Icons In WordPress Text
  33. If a hacker changed the blog_charset to UTF-7 does that make WordPress vulnerable to further attacks?
  34. Truncating custom fields
  35. Syntax error, unexpected ‘class’ (T_CLASS) on line 1 after upgrade to php 5.6.4
  36. Character encoding issue after changing servers
  37. WordPress Database Charset/Collate
  38. Why WP encodes UNICODE (UTF8) containing urls? Any drawbacks of UNICODE url?
  39. do_settings_sections() doesn’t escape quotes
  40. Allowing non-latin characters in registration
  41. JSON not valid after json_encode posts
  42. How to increase the character limit for post name of 200?
  43. Remove “Category Archives: title” at the top of a category page [duplicate]
  44. What is wp_check_invalid_utf8?
  45. WordPress load-scripts.php encoding issue
  46. Text cut off on save
  47. Strange characters on wordpress site – Not UTF8 Issue
  48. Custom DB_COLLATE (collation) value not working on fresh install?
  49. What is WordPress file encoding?
  50. Query string becomes encoded when a static page is used as homepage
  51. Site Rss not seen by browser
  52. WordPress problem with htmlentities
  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. UTF8 Encoding problems when exporting posts
  68. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  69. Special Character Appearing in my WordPress Pages Content
  70. WordPress doesn’t display accents after migration
  71. Images are not showing after moving WordPress installation from server to localhost?
  72. Problems character encoding for pages in multiple languages
  73. UTF-32be error WordPress
  74. wp_mail encode ’ in ’ in subject
  75. Function to replace comment’s accented characters before posting
  76. Outputting HTML elements through WP-API
  77. WordPress site stopped working after simply opening header.php in the wp-admin editor
  78. Problem with UTF8. italian/russian characters
  79. How to automatically convert “%” and “+” in image urls on upload
  80. Special characters in post_title replaced by ‘?’
  81. Plugin won’t output characters with diacritics properly
  82. French accented text replaced with ? in woocommerce product list
  83. How to encode correclty an url with the char “&” for an email?
  84. Character encoding issue – black diamond question marks on imported post excerpts
  85. How can I automatically add a post with Latin characters?
  86. Theme-based character encoding issue
  87. Search terms in other language turns out to question mark and symbols
  88. Migrating a WordPress site has broken UTF8 encoding
  89. Control character encode after using jquery autocomplete
  90. All of my wordpress sites showing †Ù¥
  91. filter wptexturize doesn’t work on old posts titles
  92. TinyMCE HTML Encode Backslash
  93. Plugin error on activation – breaks page encoding and prints the code of plugin php files
  94. Admin encoding problem
  95. wp-login.php ampersand in url results in 404
  96. WordPress Database Charset/Collate
  97. How to pass post title (which could include &) to Gravity Form
  98. Multisite Â&nbsp wrong encoding problem
  99. js code not stored in database currectly
  100. WordPress v3.1 Has Character Encoding Issue With Title/Permalink?
error code: 523