dimanche 22 février 2015

How to configure sqlite column so that it can take any kind of values

cur.execute("INSERT INTO taula (time, username, tweet, location) VALUES (%s,%s,%s,%s)" % (time.time(), username, tweet, location))


username , tweet and location are my values coming from twitter stream


Suppose my tweet contains - "RT @Nicksnacs4u: 1964 Ford Galaxie Dealer Promotional Model Car // by Successionary"


I need to configure my tweet column so that it can take any kind of text whether it contains special character like @Nicksnacs4u or not. Currently it it failing because some tweets contain text like #sometext , @username %, $.


Please help!!


Aucun commentaire:

Enregistrer un commentaire