Solved

SQL Server - Multi-diminsions on a column value?

Posted on 2014-02-22
1
181 Views
Last Modified: 2014-02-27
Is there an easy way for SQL Server to manage multiple dimensions of a column value like languge?  For example; if I wanted to maintain 27 different languages of a table column called "Product Description" is the only solution to create one column for each language?  What is the best solution for this?  

ProductDescription-English    varchar(max)
ProductDescription-French    varchar(max)
ProductDescription-German    varchar(max)
ProductDescription-Spanish    varchar(max)
.
.
0
Comment
Question by:hojohappy
1 Comment
 
LVL 34

Accepted Solution

by:
Brian Crowe earned 500 total points
ID: 39880270
typically I would recommend creating a separate product entry for each language since there are likely to be other values that will vary by locale like currency.

For general localization issues I would create a table called String and store the descriptions in there and then establish a foreign key relationship from the product table to the string table.

CREATE TABLE String
(
   StringID INT IDENTITY(1,1),
   Text NVARCHAR(MAX),
   LanguageID INT  --foreign key reference to a
)
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now