Hi,
I have to store the languages ​​known by an interpreter. The problem is that many languages are also known with other names (es: Ashanti, Asante, Ashante, etc...).
So, my idea is to have a Language Table in a Many-to-many relationship (called synonyms) with itself.
Language : IdLanguage, Name
Synonyms : IdL1, IdL2

How to populate the synonyms table?
An option is to insert for every couple (idL1, IdL2) also the specular couple (IdL2, IdL1).
Another option is to insert only couples where IdL1<IdL2.

With the first option it's easy to find all synonyms (idL1 = id_to_find), with the second I should query on IdL1=id_to_find or IdL2=id_to_find.
Am I right?

Do you have other solutions ?
Thanks.