SQLAlchemy and Can't Adapt?

I answered this on the ML the other day and the issue is likely that you need to enable "utf-8" client encoding for your postgresql database.

The database already has the encoding utf8 – tzulberti Jan 20 '10 at 15:07.

Below is a test case that issues your UPDATE statement in three different ways, the third of which also reproduces the odd extra "title" column in your bind parameters. All complete properly. Please ensure that you're on a recent SQLAlchemy (0.5.8 is current, nothing before 0.5.5 please) as well as a recent psycopg2.

We will need to see a full test case illustrating how you're getting an error. From sqlalchemy import * from sqlalchemy. Orm import * from sqlalchemy.ext.

Declarative import declarative_base engine = create_engine('postgresql://scott:tiger@localhost/test', echo=True) Base = declarative_base() class DocData(Base): __tablename__ = 'doc_data' serial_id = Column(Integer, primary_key=True) content = Column(UnicodeText) Base.metadata. Create_all(engine) data = 'Programas de publicidad - Soluciones Empresariales - Todo acerca de Google - Google. Com in English \xc2\xa92010 - Privacidad'.

Decode('utf-8') sess = sessionmaker(engine)() doc = DocData(serial_id=3181, content=None) sess. Add(doc) sess.flush() doc. Content = data sess.commit() engine.

Execute( DocData. __table__.update(). Where(DocData.

__table__.c. Serial_id==3181), {'content':data, 'title':'google'} ) engine. Execute("UPDATE doc_data SET content=%(content)s WHERE doc_data.

Serial_id = %(doc_data_serial_id)s", {'content': 'Programas de publicidad - Soluciones Empresariales - Todo acerca de Google - Google. Com in English \xc2\xa92010 - Privacidad', 'doc_data_serial_id': 3181L, 'title': 'Google'}) result: select relname from pg_class c join pg_namespace n on n. Oid=c.

Relnamespace where n. Nspname=current_schema() and lower(relname)=%(name)s {'name': 'doc_data'} CREATE TABLE doc_data ( serial_id SERIAL NOT NULL, content TEXT, PRIMARY KEY (serial_id) ) {} COMMIT BEGIN INSERT INTO doc_data (serial_id, content) VALUES (%(serial_id)s, %(content)s) {'content': None, 'serial_id': 3181} UPDATE doc_data SET content=%(content)s WHERE doc_data. Serial_id = %(doc_data_serial_id)s {'content': 'Programas de publicidad - Soluciones Empresariales - Todo acerca de Google - Google.Com in English \xc2\xa92010 - Privacidad', 'doc_data_serial_id': 3181} COMMIT UPDATE doc_data SET content=%(content)s WHERE doc_data.

Serial_id = %(serial_id_1)s {'content': 'Programas de publicidad - Soluciones Empresariales - Todo acerca de Google - Google. Com in English \xc2\xa92010 - Privacidad', 'serial_id_1': 3181} COMMIT UPDATE doc_data SET content=%(content)s WHERE doc_data. Serial_id = %(doc_data_serial_id)s {'content': 'Programas de publicidad - Soluciones Empresariales - Todo acerca de Google - Google.

Com in English \xc2\xa92010 - Privacidad', 'doc_data_serial_id': 3181L, 'title': 'Google'} COMMIT.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.