how to store a huge string (length 50000) in mysql using python -

how store huge string (length 50000) in mysql using python. have big string of length 50000 .i have store mysql. suggested store string blob or text type.

can me how convert string blob type

def main():     stringkey=''     stringvalues=''     keys=ccv.keys()        //ccv dictionary data structure       vectors=ccv.values()  //ccv dictionary data structure      key in keys:             stringkey='#'.join(key key in keys)     value in vectors:             stringvalues='$'.join(str(value) value in vectors)     insert(stringkey,stringvalues)     print 'insert successful'  def insert(k,v):     db = mysql.connector.connect(user='root', password='abhi',                               host='localhost',                               database='cbir')      sql= 'insert ccv(key,vector) values(%s,%s)'     args = (k,v)     cursor=db.cursor()     cursor.execute(sql,args)     db.commit()     db.close() 

error:

programmingerror: 1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near 'key,vector) values('27:1:8#27:1:9#25:2:11#6:9:8#6:9:9#6:9:6#6:9:7#6:9:4#6:9:5#27' @ line 1 

you made small error in:

'insert ccv(key,vector) values(%s,%s)' 

it should be:

"insert ccv (`key`, `vector`) values(%s, %s)" 

notice ` denoting column names.

as larry reminded me values don't have quoted parameterized queries.

if fields set longtext should work without needing convert data blobs.

the problem related syntax , not data or column types.