On Sun, Oct 11, 2009 at 5:06 PM, aditya shukla <adityashukla1...@gmail.com>wrote:
> Hello Stephen, > > > I have put the code and the traceback.Can you please help me now? .I am > scratching my head :) > > 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 > script. > > 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 appreciated. > > 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 > > > traceback > > C:\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning: > the sets module is deprecated > from sets import ImmutableSet > > cp1252 en_US > > Thanks > > Aditya > > > > > > > > > > > > > >
-- http://mail.python.org/mailman/listinfo/python-list