[sqlalchemy] Re: invalid byte sequence for encoding:utf8 Postgresql

2008-02-14 Thread [EMAIL PROTECTED]
Solvedmy faultthe file i'm reading was latin1... and I was using the standard open.. now I use: self.in_file = codecs.open(self.filename, r, latin1) after that it worked fine... thanks On 13 Feb, 16:50, Michael Bayer [EMAIL PROTECTED] wrote: On Feb 13, 2008, at 2:28 AM, [EMAIL PROTECTED]

[sqlalchemy] Re: invalid byte sequence for encoding:utf8 Postgresql

2008-02-13 Thread Michael Bayer
On Feb 13, 2008, at 2:28 AM, [EMAIL PROTECTED] wrote: Hello, I had a postgresql database: CREATE DATABASE panizzolosas WITH OWNER = postgres ENCODING = 'UTF8'; and i'm using sqlalchemy 0.4.2p3. this is my code self.metadata=MetaData() engine = create_engine(stringaDATABASE,