title: JSP/Java page encoding and database collation issue
body: <p>I have a web page with text input fields.  If the user pastes text from a Microsoft product (Word, Outlook) the long dashes (m dashes?) and apostrophes (or single quotes) are getting converted to question marks (?) when written to my database table. If they just enter text directly from the keyboard it's fine. How can I prevent or correct this issue?</p>
  
  <p>My JSP page has this above the starting  tag:</p>
  
  <pre><code>&lt;%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%&gt;
  </code></pre>
  
  <p>My Microsoft SQL 2012 Server default collation is set to:</p>
  
  <pre><code>SQL_Latin1_General_CP1_CI_AS
  </code></pre>
  
  <p>How can I fix this going forward?</p>
  
  <p>Thanks!</p>