hier mein test code.
Code: Alles auswählen
# -*- coding: iso-8859-1 -*-
from MySQLdb import *
class mysqlabfr:
def __init__(self):
self.conn = connect(host="localhost",db="test2",user="root",passwd="")
def einf(self,text1,text2):
cursor = self.conn.cursor()
a = "INSERT INTO test VALUES(0,'"+str(text1)+"','"+str(text2)+"')"
print a
cursor.execute(a)
daten = mysqlabfr()
daten.einf("testäöo","test")
INSERT INTO test VALUES(0,'te�st','test')
Traceback (most recent call last):
File "test.py", line 20, in ?
daten.einf(u"te�st","test")
File "test.py", line 16, in einf
cursor.execute(a)
File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 146, in execute
query = query.encode(charset)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe4 in position 29: ordinal not in range(128)
ich habe im forum gesucht aber leider nicht das richtige gefunden.
mfg
gerhard rogen