Hi Im using utf-8 in my mysql tables. If i insert a String with German Umlaute like Ü it is converted to Ãœ in the database, it ist returned as Ü. - What can i do that this will be correctly saved?
my connection looks like this: engine = create_engine('mysql://xxx:[EMAIL PROTECTED]/test123', echo=False, pool_size=30, pool_recycle=3600) use_unicode, or the other Parameters doesn't work for me. the table definition looks like this: raum_table = Table('raum', metadata, Column('id', Integer, ForeignKey('objekt.id'),primary_key=True), Column('name', Unicode(100)), Column('anzahl', Integer), Column('raumbezeichnung', Integer), Column('raumtyp', Integer), Column('siedlungstyp', Integer), Column('gebaeude', Unicode(200)), Column('gebaeudeteil', Unicode(200)), Column('fundstelle', Unicode(200)), Column('befundgattung', Integer), Column('befund', Unicode(200)), Column('orttyp', Integer), Column('ort', Integer) ) the mapper looks like this: mapper(Raum, raum_table, inherits=Objekt, polymorphic_identity='raum', properties={ 'personen':relation(Person, secondary = person_raum_table), 'handlungen':relation(Handlung, secondary = raum_handlung_table), 'objekte':relation(WObjekt, secondary = wobjekt_raum_table), 'eigenschaften' : relation(Eigenschaft, secondary = eigenschaft_raum_table) } ) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---