Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • Isn't the N only needed for literal strings? Commented Jul 6, 2012 at 14:56
  • Polish is a non-Latin based language???? Commented Jul 6, 2012 at 16:58
  • 2
    N means National, as in "National Varying Character", see Equivalent ANSI SQL Data Types. Commented Jun 17, 2014 at 20:16
  • I agree with this question and nobody has answered it so far, AFAICT. Maybe it could be restated as “why is it bad to let SQL implicitly convert my VARCHAR to NVARCHAR when my string literal is ASCII?”. Commented Oct 14, 2014 at 14:11
  • This question was already asked and answered here: What is the difference between varchar and nvarchar? Commented Oct 14, 2014 at 17:29