{"results":[{"role":"subject","uri":"https://justatheory.com/2004/09/mod_perl-escape-html-utf8","title":"Apache::Util::escape_html() Doesn't Like Perl UTF-8 Strings","description":null,"date":1770190874813,"image":null},{"role":"object","uri":"https://octothorp.es/~/utf-8","title":null,"description":null,"image":null},{"role":"subject","uri":"https://justatheory.com/2006/04/intelligent-mysql-configuration","title":"Intelligent MySQL Configuration","description":"James Duncan Davidson’s Configuring MySQL on MacOS X post earlier today reminded me that I wanted to blog about the configuration I came up with while installing MySQL 5 on my box. Nothing has irritated me more than when MySQL’s syntax has violated the ANSI SQL standards in the most blatant ways, or when transactions have appeared to work, but mysteriously not worked. Yes, I use Duncan’s settings to make sure that the MySQL box on my PowerBook only listens on local sockets, but I additionally add this configuration to /etc/my.cnf:","date":1770038215170,"image":null},{"role":"subject","uri":"https://justatheory.com/2008/06/citext-patch-submitted","title":"CITEXT Patch Submitted to PostgreSQL Contrib","description":"On Friday, I submitted a patch to add a locale-aware case-insensitive text type as a PostgreSQL contrib module. This has been among my top requests as a feature for PostgreSQL ever since I started using it. And as I started work on yet another application recently, I decided to look into what it would take to just make it happen myself. I’m hopeful that everyone will be able to benefit from this bit of yak shaving.","date":1751518681310,"image":null},{"role":"subject","uri":"https://justatheory.com/2005/08/windows-perl-no-utf8","title":"No UTF-8 Support on Windows?","description":"This just blows. It will be a while before Bricolage runs on Windows, then. The PostgreSQL team is understandably reluctant to simply include the whole ICU library in PostgreSQL. Maybe it could be compiled into the binaries, though?","date":1751321539627,"image":null},{"role":"subject","uri":"https://justatheory.com/2011/02/encoding-is-a-headache","title":"Encoding is a Headache","description":null,"date":1745348703825,"image":null},{"role":"subject","uri":"https://justatheory.com/2004/08/postgres-always-use-c-locale","title":"Always use the C Locale with PostgreSQL","description":null,"date":1743613962177,"image":null},{"role":"subject","uri":"https://justatheory.com/2004/09/perl-utf8-trials","title":"Lessons Learned with Perl and UTF-8","description":null,"date":1741121762814,"image":"https://justatheory.com/icon-512x512.png"}]}