>>> cu.execute("insert into measurement values (default, 'body', 56, 1, 1981, 'notype', False, '{\"%s\",\"%s\"}', 1647, '', 'bidon', 0);" % (u'éé',u'$$')) >>> cu.execute("select listanswermeasurement from measurement where idform='bidon';") >>> res = cu.fetchall() >>> res [[['test', 'test', 'test']], [['\xc3\xa9\xc3\xa9', '$$']], [['\xc3\xa9\xc3\xa9', '$$']], [['\xc3\xa9\xc3\xa9', '$$']]] >>> res[1][0][0] '\xc3\xa9\xc3\xa9' >>> type(res[1][0][0])