[orm-devel] How to handle multi language?
diedrich at tux4web.de
Sat Jun 18 11:20:35 CEST 2005
> All your suggestions got me thinking. Whenever you or anyone else
> has a moment to look at the attached, I would be greatful for
> comments/critics - this is nothing urgent.
> Any hints, comments, critic (but be nice, please!) is very welcome
Thank you very much for sharing your ideas with the list!
I'd like to make two remarks, though:
1. I don't think it is a good idea to have several rows per language
in the same table. This is going to make SELECT queries less streight
forward, because you always have to exclude those entries you don't
want for the current language. (If the parent table is the only one
you do SELECTs on that's not a problem, of course). Anyway, I'd like
to have one row per country, though dispite the face that there are
three country names, it's only one country.
2. Just a small one: I think lang_2oneColumn can be optimized by
using a JOIN so you don't need to run two queries.
Have a nice weekend!
Diedrich Vorberg <diedrich at tux4web.de> .---. / \
http://tux4web.de Tel: 02302 425269 / \ ((__-^^-,-^^-__))
\.O-O./ `-_---' `---_-'
"Unix is simple, but it takes a genius /`\_/`\ `--|o` 'o|--'
to understand the simplicity." // _ \\ \ ` /
- Dennis Ritchie | \ )|_ ): :(
/`\_`> <_/ \ :o_o:
Associate Member of the FSF #1245 \__/'---'\__/ "-"
More information about the orm-devel