..oO(Peter H. Coffin)

>On Tue, 18 Sep 2007 22:26:34 +0200, Michael Fesser wrote:
>> A third idea: Add a field 'lang' for storing a language code (2 or 5
>> chars). Make that the primary key together with the DestID field. Then
>> store one record for each language.
>
>This is the right general plan for the OP.
>
>Though for some reason, my brain is nagging me to say "Nope, primary key
>on DestID only, add another index for the DestID plus LangID" but I
>can't remember why.

PK on DestID only wouldn't be unique anymore.

Micha