Maybe someone can find another use for them, but I just finished putting together a list of tables for parsing auto-translate strings. This should be particularly useful for web tools such as roster scripts with bazaar comments.

Basically the idea is you detect auto-translated text by searching for 0xFD characters. It will then always follow this pattern:

0xFD XX YY ZZ AA 0xFD

where 0xFD are literals.

XX is the type, and will usually be 0x02. If this is the case, you will be using the auto_translate_strings table.
YY is a language code and can be safely ignored.
ZZ is the category you should use in your query
AA is the index you should use in your query

So just replace that sequence with the string retrieved from your query and voila!

The pattern is a little different if XX is not 02.

If it is 0x07 then it is an item. If it is 0x13 then it is a key item.
In either case, ZZ AA together become the id you use in your query. You will query auto_translate_items for 0x07 and auto_translate_keyitems for 0x13.