Looking for general advice on Access DB design with mixed language families
Looking for general advice on Access DB design with mixed language families
(OP)
Access 2013 (maybe migrating to SQL Server)/Windows 7 home premium
I've designed an Access db with some of my tables containing text in various European languages. If the relationship is 1 to 1 between languages (English text/German equivalent/French equivalent/etc.), I have put the text side-by-side in separate fields/columns. If not, I normally mix the languages in the same field/column with an extra field containing a LanguageID. I would like to continue my design allowing for the possibility of Arabic & East Asian languages (Japanese, Chinese & Korean).
Googling and Binging on "MS Access Multiple languages" & "MS Access Foreign languages" gets lots of hits on Computer languages & Foreign keys.
I gleaned some language basics from Wikipedia. Any general advice (pros/cons, useful links, etc.) would be welcome.
Thanks
Peter
I've designed an Access db with some of my tables containing text in various European languages. If the relationship is 1 to 1 between languages (English text/German equivalent/French equivalent/etc.), I have put the text side-by-side in separate fields/columns. If not, I normally mix the languages in the same field/column with an extra field containing a LanguageID. I would like to continue my design allowing for the possibility of Arabic & East Asian languages (Japanese, Chinese & Korean).
Googling and Binging on "MS Access Multiple languages" & "MS Access Foreign languages" gets lots of hits on Computer languages & Foreign keys.
I gleaned some language basics from Wikipedia. Any general advice (pros/cons, useful links, etc.) would be welcome.
Thanks
Peter