title: SQL Server T-SQL N prefix on string literal
body: <p>It's maybe a noob question but I found some T-SQL query example to verify database size with <code>SELECT</code> and <code>WHERE</code> clause <a href="http://technet.microsoft.com/en-us/library/ms176061.aspx" rel="nofollow">here</a></p>
  
  <p>Here is the code:</p>
  
  <pre><code>SELECT name, size, size*1.0/128 AS [Size in MBs] 
  FROM sys.master_files
  WHERE name = N'mytest';
  </code></pre>
  
  <p>My question is what does the <code>N</code> prefix mean in the <code>WHERE name = N'keyword'</code> clause? </p>
  
  <p>I always use <code>WHERE name = 'keyword'</code> before, and I don't find the differences (you can try it by yourself).</p>
  
  <p>I've googled that but I don't know the keyword I supposed to search</p>