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