Source of the famous “Now you have two problems” quote
2023-05-04 (Thursday)
Jeffrey Friedl’s Blog: Source of the famous “Now you have two problems” quote
Jeffrey Friedl’s Blog: Source of the famous “Now you have two problems” quote
DBI->connect(..., {mysql_enable_utf8 => 1}) converts MySQL varchar columns to Perl character strings (i.e. an ‘ß’ shows up as “\x{DF}”, a ‘€’ as “\x{20ac}”, etc.) But DBI->connect(..., {mysql_enable_utf8mb4 => 1})converts to Windows-1252 first, so the ‘€’ shows up as “\x{80}”. This also happens if you combine both.