title: Python mysql connector prepared INSERT statement cutting off text
body: <p>I've been trying to insert a large string into an MySQL database using pythons mysql.connector.  The problem I'm having is that long strings are getting cut off at some point when using prepared statements.  I'm currently using MySQL Connector/Python that is available on MySQL.com. I used the following code do duplicate the problem I'm having.</p>
  
  <pre><code>db = mysql.connector.connect(**creditials)
  cursor = db.cursor()
  
  value = []
  
  for x in range(0, 2000):
      value.append(str(x+1))
  
  value = " ".join(value)
  
  cursor.execute("""
                  CREATE TABLE IF NOT EXISTS test ( 
                      pid VARCHAR(50),
                      name VARCHAR(120),
                      data LONGTEXT,
                      PRIMARY KEY(pid)
                  )  
                  """)
  db.commit()
  
  
  #this works as expected
  print("Test 1")
  cursor.execute("REPLACE INTO test (pid, name, data) VALUES ('try 1', 'Description', '{0}')".format(value))
  db.commit()
  cursor.close()
  
  
  #this does not work
  print("Test 2")
  cursor = db.cursor(prepared=True)
  cursor.execute("""REPLACE INTO test (pid, name, data) VALUE (?, ?, ?)""", ('try 2', 'Description2', value))
  db.commit()
  cursor.close()
  </code></pre>
  
  <p>Test 1 works as expected and stores all the numbers up to 2000, but test 2 get cut off right after number 65.  I would rather use prepared statements than trying to sanitize incoming strings myself.  Any help appreciated.</p>
  
  <p>Extra information:</p>
  
  <p>Computer: Windows 7 64 bit</p>
  
  <p>Python: Tried on both python 3.4 and 3.3</p>
  
  <p>MYSQL: 5.6.17 (Came with WAMP)</p>
  
  <p>Library: MySQL Connector/Python</p>