title: What collation to use for a column that will have both English and Japanese text?
body: <p>I am using Sql Server 2008 and one of our requirements is to provide multi-lingual support. The main languages are English, German, French and Japanese. </p>
  
  <p>I have a table which has its COLLATION as Latin1_General_CI_AS. The column that will store the text data has this COLLATION 'Japanese_CI_AS'</p>
  
  <p>When I run the following SQL in SQL Server Management Studio (SSMS)</p>
  
  <pre><code>DECLARE @translation nvarchar(max)
  SET @translation = 'クッキー(Cookie)を許可してください'
  
  PRINT @translation
  
  UPDATE [ResourceTranslations]
  SET Translation = @translation  
  WHERE Id = 4
  </code></pre>
  
  <p>The value inserted is '????(Cookie)?????????', which is also the value that is printed out.</p>
  
  <p>Is there any chance that SSMS is having problems with the Japanese characters? It seems that the print statement is telling me that the value is being altered to '????(Cookie)?????????'  before it gets inserted in the table.</p>
  
  <p>Any help or advice gratefully accepted.</p>