This post has some general tips that I’d recommend to anyone wanting to write a multilingual web application. The majority of my code these days is PHP, but I think these tips are applicable to most web programming languages. In no particular order:
I submitted Threadbubble to AMO tonight. I wanted to work out the bugs and get it in a stable state before I put it on there and I think it’s reached that point. Hosting it on AMO will prevent potential security issues, and it has the side benefit of providing automatic updates.
I just learned recently that I’ll be presenting at OSCON 2007. Mike Morgan and I will be talking about the process we went through to localize addons.mozilla.org.
I caught wind of a Drupal meetup tonight, and since I’m going to be working with Drupal in the near future I thought I’d stop by and check it out. My main goal was to hear about other people’s experiences using Drupal in a multilingual environment.
This is probably well documented, but it's a good reminder anyway. If you've got a column in MySQL that is textual (like a varchar), you need to make sure MySQL sees the data going into it as a string. Here's an example I stumbled across today when I left out some quotation marks - `averagerating` is a varchar(255): mysql> select averagerating from addons where id=5001; +---------------+ | averagerating | +---------------+ | 0 | +---------------+ 1 row in set (0.00 sec)