title: How to implement Full-Text search in multilingual content in SQL Server
body: <p>We have a site which supports different languages. We have millions of data so in search we would like to implement <strong>SQL Server Full-Text Search</strong>.</p>
  
  <p>The table structure we have currently like below.</p>
  
  <pre><code>CREATE TABLE Product
  (
     ID INT IDENTITY(1,1),
     Code VARCHAR(50),
     ........
     ........
  )
  
  CREATE TABLE ProductLanguage
  (
     ID INT,
     LanguageID INT,
     Name NVARCHAR(200),
     ........
     ........
  )
  </code></pre>
  
  <p>We would like to implement Full-Text search in "Name" column so we have created Full-Text index on the Name column. But while creating Full-Text index we can select only one language per column. If we select "English" or "Neutral" its not returning expected data in other languages like Japanese, Chinese, French etc.</p>
  
  <p>So what is the best way to implement Full-Text search in SQL Server for multilingual content. </p>
  
  <p>Do we need to create a different table. If yes then what will be the table structure (We need to keep in mind that the Languages are not fixed, different language can be added later) and what will be search query?</p>
  
  <p>We are using SQL Server 2008 R2.</p>