'Test mixed unicode/binary arguments in executemany.'

def test_issue_364(self):

    conn = pymysql.connect(charset='utf8', **self.databases[0])
    self.safe_create_table(conn, 'issue364', 'create    table    issue364    (value_1    binary(3),    value_2    varchar(3))    engine=InnoDB    default    charset=utf8')
    sql = 'insert    into    issue364    (value_1,    value_2)    values    (%s,    %s)'
    usql = u'insert    into    issue364    (value_1,    value_2)    values    (%s,    %s)'
    values = [pymysql.Binary('\x00\xff\x00'), u'\xe4\xf6\xfc']
    cur = conn.cursor()
    cur.execute(sql, args=values)
    cur.execute('select    *    from    issue364')
    self.assertEqual(cur.fetchone(), tuple(values))
    cur.execute(usql, args=values)
    cur.executemany(sql, args=(values, values, values))
    cur.execute('select    *    from    issue364')
    for row in cur.fetchall():
        self.assertEqual(row, tuple(values))
    cur.executemany(usql, args=(values, values, values))
