Home Forums SQL Server 7,2000 Globalization Multiple Language Database Design - Additional Columns vs. Additional Tables... RE: Multiple Language Database Design - Additional Columns vs. Additional Tables...

  • Yes. I'm not sure what the best approach is (hence why we have this thread going). You may be able to put your database back to "latin" and then add seperate columns for each language outside the "latin" scope. For example, you should be able to store English, Portuguese, Spanish (all latin languages) in one NVARCHAR column, then add others for Chinese, Korean, Japanese, etc. This thread was an attempt to make that all kind of transparent without having to add more columns and more complication over time as you want to support new languages.