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)