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...

  • You certainly can add a language column in your PK. The problem is that you will have too much redundancy for non-text columns, and it will be difficult to maintain the table.

    If I am not wrong, the original question is to expose the same information in different languages.  

    For tables that accept user input, the language column is a good idea. But it's not necesarily part of PK.