Wieder was gelernt

Source of the famous “Now you have two problems” quote

2023-05-04 (Thursday)
Tags: quotes history regular expresssions perl awk Jamie Zawinski

Jeffrey Friedl’s Blog: Source of the famous “Now you have two problems” quote

Perl testing

2022-10-13 (Thursday)
Tags: perl testing

./Build test make test prove

mysql_enable_utf8mb4 doesn't work

2021-12-07 (Tuesday)
Tags: mysql perl utf-8

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.