title: Japanese/Chinese language data in SQL Server table
body: <p>So I've got an interesting problem that I need help with faster than I can get my skills with SQL Server up to par.</p>
  
  <p>We have a table that contains a bunch of text, all of it in different languages. Most of this data appears correctly in the browser, however, anything in Chinese or Japanese gets completely mangled by the browser. </p>
  
  <p>This is an ASP.old app that we're using to display the data which comes from a server running MS SQL Server 2005.</p>
  
  <p>Before, we had this same problem and we solved it by changing the encoding in the ASP pages. These files have not changed since we did that, but the problem has resurfaced. Thus I must conclude that the problem rests with the database since that's the only thing that has been updated since we last fixed it. </p>
  
  <p>So far I've been trying to look into collation, but I'm nowhere near an expert on SQL so it's been difficult. </p>
  
  <p>I can provide more info if needed, anything that will help someone get me to the answer, short of URL's (confidentiality and all).</p>
  
  <p>If anyone has any ideas, I would appreciate it very much.</p>
  
  <p>ADDITIONAL INFO:</p>
  
  <p>-column type is 'ntext'</p>