title: SQL Insert multilingual characters
body: <p>I am trying to create a table in my MS SQL database for Languages.<br/>
  I want to store an English name of Language and a local name of language in the database.
  i.e.<br/>
  <strong>Language, Language(local)</strong><br/>
  English, English<br/>
  German, Deutsch<br/>
  Italian, Italiano<br/>
  Japanese, 日本語<br/>
  ...<br/>
  ...<br/><br/></p>
  
  <p>I have 279 languages that I want to import, but when I import it shows '?????' for some like japanese, Russian and arabic etc<br/>
  The database Collation is Latin1_General_CI_AS.<br/>
  <br/>
  I would also like advise on multilingual websites; if i have a database of product descriptions and I want to have translation in multiple languages, should I go for separate databases or Can I have translation in one databse? (I prefer not to duplicate data!). Anything else to make sure users are able to write comments in different languages (char encoding on web?) and can be stored in database.<br/>
  <br/>
  <strong><em>Thanks to an advise I have managed to import data but, I cannot select and view correctly and therefore cannot verify if import was successful; I am getting following results on select:</em></strong><br/>
  <img src="https://i.stack.imgur.com/ju9cy.jpg" alt="Select language result"></p>