UTF-8 is prepared for world domination, Latin1 isn’t.
If you’re trying to store non-Latin characters like Chinese, Japanese, Hebrew, Russian, etc using Latin1 encoding, then they will end up as mojibake. You may find the introductory text of this article useful (and even more if you know a bit Java).
Note that full 4-byte UTF-8 support was only introduced in MySQL 5.5. Before that version, it only goes up to 3 bytes per character, not 4 bytes per character. So, it supported only the BMP plane and not e.g. the Emoji plane. If you want full 4-byte UTF-8 support, upgrade MySQL to at least 5.5 or go for another RDBMS like PostgreSQL. In MySQL 5.5+ it’s called utf8mb4
.
Related Posts:
- Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
- What specific database privileges does WordPress need?
- What is the most secure way to set up the MySQL user in WPMU?
- WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
- Running WordPress from MySQL Cluster with HAPRoxy
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- When to use SELECT … FOR UPDATE?
- ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
- Create a new database with MySQL Workbench
- Column ‘user_id’ in field list is ambiguous
- Database sharding vs partitioning
- Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
- Search for all occurrences of a string in a mysql database
- #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
- How to convert a string to date in MySQL?
- MySQL COUNT DISTINCT
- How to update a record using sequelize for node?
- Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
- Convert MySQL to SQlite [closed]
- Create a temporary table in a SELECT statement without a separate CREATE TABLE
- Convert partially non-numeric text into number in MySQL query
- Mac install and open mysql using terminal
- MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
- MySQL: What’s the difference between float and double?
- How can I search (case-insensitive) in a column using LIKE wildcard?
- MySQL Select Multiple VALUES
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- How to unblock with mysqladmin flush hosts
- Node.js MySQL – Error: connect ECONNREFUSED
- MySQL: Cloning a MySQL database on the same MySql instance
- mysqldump data only
- PHP date() format when inserting into datetime in MySQL
- WordPress mysqli and PDO
- Alternative to mysql_real_escape_string
- Increment value (value = value+1) of $wpdb->update
- How can I debug my database connection for unit testing?
- Same option_id=0 for 2 options in wp_options?
- How to let a user choose an authors and save it to the database?
- How to remove ‘GROUP BY’ from SQL query produced from get_posts?
- MySQL LIKE not working
- Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
- How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
- Create a quick start wordpress installation [closed]
- Update a WordPress post or page takes 60+ seconds
- Join new table with SQL query
- MySQL crashed because of the large number of requests
- Why doesn’t this code add a table to my database?
- SQL database export-import
- Can Someone Help Me Fix This WordPress Missing Argument Error?
- How can I fix WordPress installation errors?
- How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
- Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
- SQL Database, repeated tables?
- Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
- Code to remove authors with no posts connected to them
- SQL Query in WordPress – Getting Impossible WHERE error
- SQL syntax error when getting data for a url
- WordPress create database not working
- Import CSV to MySQL, with custom registration field information
- database optimization and server errors
- Setting up WordPress Locally on WAMP for a new site (with one already)
- Calling mysql_query() on another database, assumes WordPress using that database
- WordPress VIP realpath Alternative?
- querying user bookmarks from a large number of bookmarks
- Pull post name from value of a specific meta key
- PHP variables in mysql query
- Php Mysql Terms
- Export SQL query based on custom field?
- How to fix the amount of comments displayed for each post?
- How do I echo all users’ display_name and their meta_value who have a certain meta_key?
- Lock wait timeout exceeded; try restarting transaction
- How to simulate web traffic to test performance of a website
- SQL query to change custom field in WordPress database
- SQL. Select category descendants
- MySQL Actibity without any active visitors via Google Analytics
- How to configure WordPress Database for CentOS 7
- Why is local wordpress install calling live site executions?
- Add row to SQL array
- Display MySQL as part of a Page
- Migration of wordpress database from mariadb 10.0.20 to 5.5.50
- Use custom query if main search query returns zero results in wordpress
- WP Meta Query – mixed AND / OR query doesn’t work
- Geographical proximity query using post_meta
- Second completely independent and disposable WordPress installation in subdirectory?
- get_results suddenly not working on a single table
- Internal error (500) on local & Fatal error on live when trying to access post type edit screen
- Query sql for truncate post_content in wp_posts table
- Foreach only outputs if id is 0
- Using queries in and i see 7000+queries?
- “Error 1064” when importing msql database after updating wordpress version to 4.2.1
- remove wordpress post links
- SQL get last entry of a specific gravity form
- mysqldump to a tar.gz
- Postgres equivalent to MySQL’s \G?
- How to check what port mysql is running on
- Where is my mysql log on OS X?