title: pgadmin - ERROR: invalid input syntax for type bigint
body: <p>I'm trying to import a CSV file via pgadmin dn it keeps throwing an error on the first line</p>
  <pre><code>ERROR:  invalid input syntax for type bigint: &quot;﻿8668394&quot;
  </code></pre>
  <p>I recognize the &quot;&quot; say it is is trying to import the integer as a string but I can't understand why this is the case.  When I open the CSV in notepad++ it doesn't show any quote marks or formating that might be causing this.  This is what I see in notepad++</p>
  <pre><code>8668394,Damoujia,China,Asia/Shanghai,36.54356,119.81326 CR LF
  9123882,Shanwang,China,Asia/Shanghai,36.5454,118.711 CR LF
  11969451,Katang Ailieke,China,Asia/Urumqi,38.15279,85.51784 CR LF
  12110889,Wulong,China,Asia/Shanghai,29.32431,107.76056 CR LF
  12324243,Yingqiu,China,Asia/Shanghai,36.52663,118.99285 CR LF
  </code></pre>
  <p>Does anyone have any idea what is going wrong here?</p>