title: Convert a pyodbc.Row to a string
body: <p>I need to convert a pyodbc.Row to a string. The internet provides several suggestions, none of which seem to work for me.</p>
  
  <pre><code>row = cursor.fetchone() 
  #unicodedata.normalize('NFKD', row).encode('ascii','ignore') #TypeError: must be unicode, not pyodbc.Row
  #row.fieldname.encode('utf8') #AttributeError: 'pyodbc.Row' object has no attribute 'fieldname'
  tblName = str(row)
  tblName.replace("text:u","").replace("'","")
  tblName = tblName.encode('utf-8')
  print tblName
  </code></pre>
  
  <p>The above either give an error (shown in comment) or seems to have no effect as shown in the output here:  </p>
  
  <pre><code>(u'myTableName', ) # print tblName
  </code></pre>
  
  <p>SQL is</p>
  
  <pre><code>tablesWithId = "select table_name \
                            from INFORMATION_SCHEMA.COLUMNS \
                            where COLUMN_NAME like 'MyId' "
  cursor.execute(tablesWithId)
  </code></pre>
  
  <p>Python 2.7</p>