title: Rails: Error when trying to save a special character to database when using ActiveRecord and TinyTDS
body: <p>I'm trying to save this character "É" as part of a string using ActiveRecord to my sql server using TinyTDS. Any idea on what I need to do to get rid of the following error?</p>
  
  <pre><code>Exiting
  /var/lib/gems/1.9.1/gems/activerecord-sqlserver-adapter-3.2.10/lib/active_record/connection_adapters/sqlserver/database_statements.rb:387:in `execute': TinyTds::Error: Error converting characters into server's character set. Some character(s) could not be converted
  </code></pre>
  
  <p>The string I imagine it's erroring out on is the following: <code>JEREMÉ</code></p>
  
  <p>Below is my code I'm using to parse the file...</p>
  
  <pre><code>csv = CSV.parse(csv_text, :headers=&gt;false, encoding: "UTF-8")
  csv.drop(2).each do |row|
      person = Person.new(:lastname =&gt; row[0], :firstname =&gt; row[1])
      playerstats.save
  end
  </code></pre>