title: Pymssql, How to use it to read unicode data from MSSQL2008
body: <p>I've used pymssql-1.0.2 and freetds-0.82.7 on ubuntu-10.10.
  Also, I have a mssql2008 server on windows-7. 
  I can connect with mssql from ubuntu using pymssql and freetds.
  But I can't get unicode data from mssql database. Database collation is Cyrillic_General_CI_AS.</p>
  
  <h2>My freetds.conf file looks like this:</h2>
  
  <pre><code>[mssql2008]
      host=10.0.0.34
      port=1433
      tds version=7.0
  </code></pre>
  
  <h2>My code looks like this:</h2>
  
  <pre><code>   conn = pymssql.connect(host=10.0.0.34\mssql2008, user=***, password=***, database=eoffice, as_dict=true, charset='iso-8859-1')
     crms = conn.cursor()
     crms.execute('SELECT cc_Name FROM tblHR_CodeClass')
     for row in crms.fetchall():
        raise u"Succeeded! Test data: " + row['cc_Name']
        break
  </code></pre>
  
  <p>Expected result is: "Өмнөговь аймаг"
  Actual result is: "ªìíºãîâü àéìàã"</p>
  
  <p>When I use 'UTF-8' charset, the fetchall() call throws an error means the utf8 can't read the data which is out of range of code page.</p>
  
  <p>How to get unicode data as it stored on mssql database?
  Please give your hand!</p>
  
  <p>Regards,
  Orgil</p>