Special characters in WordPress UTF-8 [closed]

Edit:

Do you have <meta charset="utf-8" /> in your <head> tag? A user here fixed a similar problem with character encoding by adding this.

There are actually many Google results that come up searching for utf-8 character encoding in wordpress.

Also, does pasting the text into the HTML view of the editor and saving it make any difference?

Below is not such a good idea as @toscho explained in comments.

I am not sure if this is the best method to fix the problem but this worked for one of my clients’ websites.

Find these two lines in your wp-config.php file:

define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

And comment them out like so:

//define('DB_CHARSET', 'utf8');
//define('DB_COLLATE', '');

Related Posts:

  1. Search and replace special characters (å,ä,ö) for image attachments only in database
  2. Search Character Set Problem
  3. Character encoding issue – black diamond question marks on imported post excerpts
  4. WordPress character set issue
  5. Why is converting my database to UTF-8 truncating entries?
  6. MySQL SELECT increment counter
  7. Exclude Statement in SQL
  8. Is it fine to have foreign key as primary key?
  9. Detecting errors generated by $wpdb->get_results()
  10. wpdb update add current timestamp not working
  11. Restoring WordPress posts from database only
  12. Displaying content from one WP site on separate WP site
  13. Lost the `wp_options` table: what’s the best way to restore the site?
  14. Performance Gains of Relational DB Setup
  15. Slow wp_term_relationships query
  16. How to use “TRUNCATE TABLE” MySQL statement?
  17. How to initialize $wpdb?
  18. Organizing WP Pages based on old website database
  19. Export wordpress table to excel
  20. Meta query interfering with orderby relevance
  21. Why is Woocommerce writing in my wp_comment table?
  22. How to implement content from external database into WordPress text page? [closed]
  23. Strange Deadlock database error for the query “Delete From wp_options”
  24. Storing textbox values in Database
  25. WooCommerce – Query for ordered products
  26. PHP variable in WordPress database query
  27. Differences between add_post_meta and update_post_meta
  28. Is a direct or import approach safer for migration into WordPress?
  29. Tons of Twitter rows in my database
  30. Why can’t I swap a DB in a WP install? [closed]
  31. How do I reset a self-hosted WordPress URL?
  32. Select Multiple meta_value from WP DB; Single Query
  33. One post carries 30 postmeta values, is this too much?
  34. Is it possible to split database tables using HyperDB?
  35. What happens if I overwrite the current wp_options table with a backup from a week ago?
  36. CRUD operations using WordPress database API
  37. Display SQL that wordpress is running
  38. Critical error in final stage of website launch – URLs are BROKEN!
  39. How do I get WordPress login to ignore the password input if a particular username is used?
  40. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  41. How to resolve Connections using insecure transport are prohibited while –require_secure_transport=ON
  42. How to Mirror WordPress database from Remote server to Local server
  43. WordPress is not creating table in database after activating plugin,
  44. How do I delete these post types in my WordPress database?
  45. How do I query wp_options for expired transient pairs with MySQL commands?
  46. WordPress returns to an old version
  47. data (html) migration to posts
  48. Super slow queries from author archive pages killing my database
  49. localize elements in database
  50. Use same database on main domain & sub domain
  51. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  52. Why user_pass column in wp_users table is varchar(64)
  53. Best practice to limit results in get_row()?
  54. How to migrate a database from a server to another
  55. Which table (and column) has the content of configured get_post_meta?
  56. Serialize data before inserting into the DB
  57. Reinstalling wordpress from database breaks the site
  58. how to count click tab menu and insert to database
  59. Adding prefix to WordPress database tables breaks admin capabilities?
  60. What is the best way to resurrect and update my old WordPress site?
  61. Pages from custom table
  62. Trouble running $wpdb->query() with last_insert_id
  63. Using $wpdb | checking entered email against existing emails in db
  64. wp-cli: Error establishing a database connection: undefined constant DB_USER
  65. Can I customised default WP table
  66. Woocommerce – Check product stock availability from external database
  67. Get results from wordpress data custom table
  68. Outputting query results
  69. Help With a Large WordPress Based MySQL Database on Shared Hosting
  70. How to display data from db in select list [closed]
  71. Will adding & modifying default WordPress table index break future WordPress update
  72. Database migration issues – Error #1046 No database selected
  73. echo site_url() returns a different value than what is in the database siteurl field
  74. Can two domains use the same database?
  75. Native timestamp on wp_options option
  76. SELECT rows between two datetimes when the range is dynamic [closed]
  77. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
  78. How to fix Uploaded to this post option to see group of images uploaded to a post?
  79. adding user_id and name to a separate table whenever a user register based on role
  80. How to access a table in a wordpress database using REST API?
  81. error establishing a database connection 3
  82. User saved through WordPress backend does not show up in database table users
  83. Correct and secure way to access a custom SQL database in a custom PHP template file
  84. Adding featured for post using database
  85. Missing latest posts and options after DB migration via phpMyAdmin
  86. get_the_terms is not working
  87. Custom metabox does not store data
  88. Return image urls with specific base string?
  89. Local host to server import problem
  90. Restoring .sql backup results in “Error establishing a database connection”
  91. Link to handle $_GET request
  92. WordPress sync with phpbb
  93. “MySQL server has gone away” since update to 3.8
  94. featured image not showing up with mysql_connect
  95. Getting deleted users in database
  96. Options of accessing wordpress data from mobile app
  97. Getting data from a table using a query
  98. Database interaction (private-public) [closed]
  99. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  100. WP Multisite Users Not Linking

Leave a Comment