Question : The scenario is a SQL Server instance, a database which is data fed using BULK INSERT operations mainly, […]
Tag: encoding
MySQL Cluster node utf8
Question : I have configured MySQL Cluster (5.6) with two data nodes and managment node. Problem is that I cannot […]
Remove characters from PostgreSQL database causing encoding errors
Question : I have a PostgreSQL 10 database that uses WIN1252 encoding. One of my columns has values that cause […]
Restoring SQL_ASCII dumps to a UTF8-encoded database
Question : I’ve got a Postgres 8.4 environment where the encoding on all our databases is set to SQL_ASCII – […]
How can I know if there is data loss when converting mysql character set(s)?
Question : I’m converting a large (70G) legacy mysql database that is mostly utf8 (but with a sprinkling of other […]
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 […]