[Tutor PyCZ] nacteni ze souboru (asi ansi), prevod na unicode

[rajcze]

hmm... tak to asi nebude uplne ok... chjo...
myslel jsem, ze kdyz to prozenu fci unicode, vypadne z toho neco takovyho:

>>> for acr in ucitele:
...     acronym=unicode(acr,'cp1250')
...     name=unicode(ucitele[acr],'cp1250')
...     acronym
...     name
...
u'Mik'
u'Mikyskov\xe1'
u'Men'
u'Men\u0161\xedkov\xe1'
...

jenze kdyz chci provest mysql dotaz, zas to rve o encode erroru :(

>>> acronym
u'Bra'
>>> name
u'Brad\xe1\u010dov\xe1'
>>> query=u"insert into profesori(acronym,name) values('"+acronym+"','"+name+"')
"
>>> query
u"insert into profesori(acronym,name) values('Bra','Brad\xe1\u010dov\xe1')"
>>> mysql.execute(query)
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "I:\PYTHON23\Lib\site-packages\MySQLdb\cursors.py", line 137, in execute
    self.errorhandler(self, exc, value)
  File "I:\PYTHON23\Lib\site-packages\MySQLdb\connections.py", line
33, in defaulterrorhandler
    raise errorclass, errorvalue
UnicodeEncodeError: 'ascii' codec can't encode characters in position
54-55: ordinal not in range(128)

nevim.. asi su fakt tupej....
zkusil sem asi 6 postupu podle googlu (dokonce i nacitani souboru pres
codecs.open(filename,encoding='cp1250',mode='r') ), ale stejne nic :(
netusite nekdo ?
diky rajcze
btw: nemam to poslat do ne-novackovskyho mailing listu ?