{"id":219,"date":"2003-05-10T21:13:56","date_gmt":"2003-05-10T21:13:56","guid":{"rendered":"tag:owlfish.com,2004:colinweblog.20030510211356"},"modified":"2003-06-30T23:21:00","modified_gmt":"2003-06-30T23:21:00","slug":"10052003","status":"publish","type":"post","link":"https:\/\/www.owlfish.com\/weblog\/2003\/05\/10052003\/","title":{"rendered":"TALAggregator &#038; MySQL"},"content":{"rendered":"<p>I&#8217;ve released version 0.4 of <a href=\"http:\/\/www.owlfish.com\/software\/TALAggregator\/index.html\">TALAggregator<\/a>, my RSS aggregation software.  This release fixes a problem where some feeds would not be successfully parsed because of the interaction between MySQL and Python when handling Unicode strings.<\/p>\n<p>The source of the bug is that the MySQL interface in Python can do automatic conversion to and from Unicode for VARCHAR columns.  Unfortunately it doesn&#8217;t perform this magic for LONGTEXT columns, leading to all sorts of confusion on my part.  It&#8217;s should be solved now &#8211; I&#8217;ve disabled the automatic conversion and do it all myself.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve released version 0.4 of TALAggregator, my RSS aggregation software. This release fixes a problem where some feeds would not be successfully parsed because of the interaction between MySQL and Python when handling Unicode strings. The source of the bug is that the MySQL interface in Python can do automatic conversion to and from Unicode [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/posts\/219"}],"collection":[{"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/comments?post=219"}],"version-history":[{"count":0,"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/posts\/219\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/media?parent=219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/categories?post=219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.owlfish.com\/weblog\/wp-json\/wp\/v2\/tags?post=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}