Multilingual Database Application

[eluser]gvillavizar[/eluser]
[quote author="Federico Gonzalez" date="1269891295"]Hi,

I agree with Isern Palaus, but if you table is a lot more complex, you must split only the multilanguage texts.

Example:

products
--------
product_id
category_id
price
weight
size

products_texts
--------------
product_id
language_id
title
description

You need to translate only text fields, because dates and numbers have no language

Saludos! Federico[/quote]

Of course, that's my approach, maybe I didn't expressed it correctly, but that's what I meant.

[eluser]Isern Palaus[/eluser]
[quote author="Federico Gonzalez" date="1269891295"]I agree with Isern Palaus, but if you table is a lot more complex, you must split only the multilanguage texts.[/quote]

You're totally right. I designed this way to make a e-Commerce system and their products. The prices is in $ and € so I used the same thing to do it.

Saludos,
Isern