Software Engineering

Chinese characters in Mysql: Dont forget the collation

Posted in Databases, Ruby on Rails, Software Engineering on October 16th, 2006 by leodirac – Be the first to comment

I recently conquered another oddity in using chinese characters in MySql. Apparently, it’s not enough to set the database’s character set to UTF-8. You also need to set the collation to a utf-8 collation. You might think the collation is only important for sorting, but theres’ more to it. If you have selected a case-insensitive collation, then it is also used to determine equality. If the collation doesn’t understand character boundaries properly, then you run into strange problems. The database was convinced two very different chinese characters were the same because their UTF-8 encodings when interpretted as 1252 had similar…

...full article


Rhapsody.com comes out of beta

Posted in Ego, Music, Software Engineering on October 5th, 2006 by leodirac – Be the first to comment

Small note of personal pride and pride in my team at work: www.rhapsody.com has stripped off its “Beta” branding with a fresh new design and cool new AJAXy features including an improved web player and better personalization. We launched last night, which was unusually stressful. Our load test numbers weren’t glowingly positive. And if the servers couldn’t handle the load, things could get really bad. Normally, we’d just roll back to a previous version of the code, but because of marketing requirements around a new product launch, we couldn’t do that. So last night after we launched and the servers…

...full article


RealTime: The Newest RSS Reader on the Block

Posted in Software Engineering on September 26th, 2006 by leodirac – Be the first to comment

“Be the first to know.” “The feed reader your mom can understand.” Whatever tag line you want to hang on it, RealTime has launched and it’s pretty cool. It’s a web-based feed reader with an integrated browser/desktop toolbar and screensaver. My good friend Mason has been dedicating his life to this product for a while, and it shows. It’s slick and pretty and is built on some pretty darned cool technology. The toolbar is a win32 shell hosting MSHTML frames (which probably still has a few lines of code in it that I wrote way back in the day) with…

...full article