Question : I’m converting a large (70G) legacy mysql database that is mostly utf8 (but with a sprinkling of other […]
Tag: encoding
MySQL silently replaces UTF chars with literal question marks
Question : I’m experiencing a situation similar to this SO question i.e. I’m working with a legacy database which has […]
UTF-8: showing correct in database, but not in webpage
Question : When i upload data from php post forums “हिन्दी” language, changed into “à¤¹à¤°à¤¿à” in database but looking correct […]
Postgres copy data with xYY as plain string instead of interpreting as encoded string
Question : I have a log file full of URLs, generated by Bro IDS. When Bro logs a URL with […]
Different characters, same ASCII code?
Question : I have this query that throws two results: SELECT id FROM table1 WHERE id like ‘nm041033%’ nm0410331 nm0410331 […]
What is the impact of converting latin1/latin1_swedish_ci to utf8mb4/utf8mb4_unicode_ci?
Question : I was facing some issues with the character’s encoding. Those are resolved by updating the CHARACTER and COLLATE […]
mysqldump dumps different data with and without –no-create-info
Question : mysqldump dumps different representations of data when called with/without –no-create-info. Test case First, create the test table and […]
Encoding issue with SQL Server VARCHAR column retrieved in Python
Question : We recently had an issue with encoding related to a field that’s being stored as a varchar(120) in […]
Client Encoding Mismatch when creating new database
Question : I’m upgrading a program for work that uses postgres 9.2.4. When the program is run for the first […]
Where can we find a copy of the “sakila” toy database with uncorrupted city names?
Question : The “sakila” toy database which is available by download as https://downloads.mysql.com/docs/sakila-db.zip from https://dev.mysql.com/doc/index-other.html contains a city table whose […]