title: Spark - Strange characters when reading CSV file
body: <p>I hope someone could help me please. My problem is the following:</p>
  
  <p>To read a CSV file in Spark I'm using the code</p>
  
  <pre><code>val df=spark.read.option("header","true").option("inferSchema","true").csv("/home/user/Documents/filename.csv")
  </code></pre>
  
  <p>assuming that my file is called <code>filename.csv</code> and the path is <code>/home/user/Documents/</code></p>
  
  <p>To show the first 10 results I use</p>
  
  <pre><code>df.show(10)
  </code></pre>
  
  <p>but instead I get the following result which contains the character � and not showing the 10 results as desired</p>
  
  <pre><code>scala&gt; df.show(10)
  +--------+---------+---------+-----------------+                                
  |     c1|      c2|      c3|              c4|
  +--------+---------+---------+-----------------+
  |��1.0|5450|3007|20160101|
  +--------+---------+---------+-----------------+
  </code></pre>
  
  <p>The CSV file looks something like this</p>
  
  <pre><code>c1  c2      c3     c4
  
  1   5450    3007    20160101
  
  2   2156    1414    20160107
  
  1   78229   3656    20160309
  
  1   34963   4484    20160104
  
  1   7897    3350    20160105
  
  11  13247   3242    20160303
  
  2   4957    3350    20160124
  
  1   73083   4211    20160207
  </code></pre>
  
  <p>The file that I'm trying to read is big. When I try smaller files I don't get the strange character and I can see the first 10 results without problem.</p>
  
  <p>Any help is appreciated.</p>