title: SQL Server bcp parameter, native, character, Unicode native, Unicode character, when to use each?
body: <p>I'm reading <a href="http://msdn.microsoft.com/en-us/library/ms191516.aspx" rel="nofollow noreferrer">this page</a> that describing the bcp utility. It states that:</p>
  <blockquote>
  <p>This section contains the following examples that show how to use bcp
  commands to create a non-XML format file:</p>
  <pre><code>A. Creating a non-XML format file for native data
  
  B. Creating a non-XML format file for character data
  
  C. Creating a non-XML format file for Unicode native data
  
  D. Creating a non-XML format file for Unicode character data
  </code></pre>
  <p>The examples use the HumanResources.Department table in the
  AdventureWorks2012 sample database. The HumanResources.Department
  table contains four columns: DepartmentID, Name, GroupName, and
  ModifiedDate.</p>
  </blockquote>
  <p>I'm not clear what does these types mean? When to use each?</p>
  <p>Thanks.</p>