character-set Archives

MySQL silently replaces UTF chars with literal question marks

By adminPosted on August 21, 2022

Question : I’m experiencing a situation similar to this SO question i.e. I’m working with a legacy database which has […]

By adminPosted on August 11, 2022

Question : It is one of the commonly used character sets. What does it stand for? Is it an acronym […]

By adminPosted on July 31, 2022

Question : Currently, whenever I create a new MySQL database, I use utf8mb4 as a character set and utf8mb4_unicode_520_ci for […]

By adminPosted on July 14, 2022

Question : I have a table with a collation defined on a column: CREATE TEMPORARY TABLE test_table ( utf8_col VARCHAR(255) […]

By adminPosted on June 25, 2022

Question : In MySQL/MariaDB, I set the connection character set to UTF-8: SET NAMES ‘utf8mb4’; SET CHARACTER SET ‘utf8mb4’; There […]

By adminPosted on June 19, 2022

Question : I was facing some issues with the character’s encoding. Those are resolved by updating the CHARACTER and COLLATE […]

By adminPosted on June 19, 2022

Question : When trying to import a database from a .mysql file, I get an error: ERROR 1115 (42000) at […]

By adminPosted on June 15, 2022

Question : mysqldump dumps different representations of data when called with/without –no-create-info. Test case First, create the test table and […]

By adminPosted on May 20, 2022

Question : I tried to migrate my AWS RDS instance from Aurora to MySQL. I created a dump file from […]

By adminPosted on April 24, 2022

Question : I’ve been struggling for days with a problem on a MS SQL database. Here is the situation: I […]