everywhere I need a multilingual string in my DB, I replace the field by a MESSAGE GUID (getGUiD with rough option)
Then I have a message file in which each record has:
- unique GUID as identifier (not the same one)
- Language code (nation())
- MESSAGE GUID (the one stored in the main file)
- the real string, in the matching language
and I have a composite key with MESSAGE GUID+Language code
so in queries, I can link on the MESSAGE GUID and add a condition on the language code to get what I need, or I can use a hfilter, of course.