Detect and Repair Double-Encoded UTF-8 Text
Recognize common double-encoded UTF-8 patterns, reverse a known Windows-1252 mis-decoding in PHP, and avoid corrupting already-correct rows.
Author: Sergey Kornilov
Unicode Normalization: NFC vs NFD
Understand why visually identical Unicode strings can compare differently and when to normalize text to NFC or NFD in JavaScript and databases.
Fix Invalid UTF-8 Errors in JSON
Find and repair malformed UTF-8 before JSON encoding in PHP, preserve error visibility, and avoid silently discarding corrupted input.
Fix Mojibake After a MySQL Migration
Diagnose and repair garbled text after a MySQL migration by separating stored bytes, column metadata, connection character sets, and application output.
Convert Windows-1252 Text to UTF-8
Convert Windows-1252 text and files to UTF-8 without losing smart quotes, dashes, euro signs, or other characters commonly mistaken for ISO-8859-1.
Move a MySQL Database to a New Server with Minimal Downtime
Move a MySQL database with a consistent seed copy, replication catch-up, controlled cutover, validation, and a rollback window.
Convert a MySQL Database to utf8mb4 Safely
Convert MySQL schemas, tables, and text columns to utf8mb4 with an inventory, explicit collation choice, index checks, and staged verification.
Fix SQL Server Certificate Chain Not Trusted Errors
Fix SQL Server certificate chain not trusted connection errors by validating the server name, certificate chain, driver encryption defaults, and client trust.
Fix SQL Server Collation Conflicts Between Databases
Resolve SQL Server collation conflict errors in cross-database joins, temp tables, UNION queries, and comparisons without changing more schema than necessary.
Move SQL Server Database Files to Another Drive
Relocate SQL Server MDF, NDF, and LDF files safely with ALTER DATABASE MODIFY FILE, an offline window, correct permissions, and verification.