| 02:28 | <Hixie> | TabAtkins: because it undermines my ideal, namely that the standard should be good enough and be a close enough match to the implementors' desires that they would want to implement it without prompting |
| 08:04 | <annevk> | :( |
| 08:04 | <annevk> | DreamHost is still at MySQL 5.1 |
| 08:04 | <annevk> | meaning http://golem.ph.utexas.edu/~distler/blog/archives/002539.html is still broken |
| 08:27 | <annevk> | so yeah, I tried putting đź’© in a blog entry and it failed miserably |
| 09:40 | <matjas> | annevk: surely they must be planning to upgrade to MySQL 5.3.3+ sometime? |
| 09:41 | <matjas> | annevk: back when my server had an outdated mysql, I just took care of it with some PHP string replacements |
| 09:41 | <matjas> | `{tetragram}` became `𝌆`, etc… annoying but at least it works |
| 09:42 | <matjas> | whenever someone left a comment using any other astral symbol, i would have to go in and add another dictionary entry – but luckily that never happened |
| 09:44 | <matjas> | also, converting your dbs and tables to utf8mb4 isn’t as simple as that blog post makes it seem |
| 09:44 | <matjas> | VARCHAR(191) is the new VARCHAR(255), for example |
| 09:46 | <matjas> | (for HTML, you could of course use character references) |
| 09:47 | <matjas> | (didn’t we talk about this before in #whatwg?) |
| 09:57 | <annevk> | matjas: we did, but I started looking into updating my stuff today |
| 09:59 | <annevk> | matjas: the comment in the MySQL documentation makes it seem as though the argument to CHAR is counting characters |
| 10:20 | <matjas> | i’d suggest using utf8mb4_unicode_ci instead of utf8mb4_bin, though |
| 10:20 | <matjas> | why would anyone want to use utf8mb4_bin? |
| 10:21 | <matjas> | i might do a write-up on how i converted my stuff |
| 10:21 | <matjas> | in case it helps anyone |
| 10:46 | <annevk> | matjas: I'm not actually using MySQL for anything other than dumb storage so it doesn't matter much for me I guess |
| 10:46 | <annevk> | at least not at the moment |
| 10:47 | <annevk> | matjas: but how to convert existing stuff and how to set up new stuff is always good to have given the rotten defaults :/ |
| 11:23 | <Velmont> | matjas: So it's on mainline, I guess you got my email(?) |
| 14:06 | <matjas> | Velmont: huh? |
| 15:21 | <Velmont> | matjas: The var var, for, while; fix :-) |
| 15:45 | <zewt> | i wish all of the "reflected the content attribute of the same name" bits would link to said bits, since that's where I always land |
| 15:48 | <zewt> | http://www.jwz.org/blog/2012/07/non-bouncy-layouts/ i'd have expected setting img @width and @height to do this, but it doesn't :( |
| 15:49 | <zewt> | eg. saying <img width=800 height=200 style="width: 100%; height: auto;"> to always layout as if it had an 800x200 image loaded |
| 15:51 | <zewt> | (probably throw in display: inline-block for completeness, not that that helps) |
| 21:33 | <matjas> | Velmont: ah, got confused by your IRC nick, sorry — yeah I got the mail, thanks! |