Inserting into a database

aditya shukla adityashukla1983 at
Mon Oct 12 02:06:31 CEST 2009

Hello Guys

I am using python 2.6 on windows 7 and MySQLdb to make connections to the
database.The issue here is that I  am not able to insert from the python
script to the database.When I run the same query in mysql query brower then
the insert statement works .I am able to select from the database  using the
python script.The connection is fine.I am using Aptana to write the python

I thought this could be a problem of the collation or character set problem
the default character set  of the system is cp1252 which corrosponds to
latin_1 on mysql , I have chosen that and still no help. Any help is

this what the code looks like.

db = MySQLdb.connect("localhost","root","juventus12","factoids",charset =
"utf8", use_unicode = True )
cursor= db.cursor()   # i added charset = "utf8", use_unicode = True just
now and changed the character set of mysql still no help.

cursor.execute("""INSERT INTO question_table
(question_id,source_id,question) VALUES (5,1,"question")""")

language, output_encoding = locale.getdefaultlocale()

print output_encoding, language


C:\Python26\lib\site-packages\MySQLdb\ DeprecationWarning:
the sets module is deprecated
  from sets import ImmutableSet

cp1252 en_US


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Python-list mailing list