I have the same problem, I've installed pysqlite (2.5.5) from sources, and after I've removed it everything is ok.
I've tried to install the last one because I had a common problem: ProgrammingError?: (ProgrammingError?) You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings. u'INSERT INTO financialaccount (title, "order", "storedNumber", "parentId") VALUES (?, ?, ?, ?)' ['\xd0\xa2\xd0\xbe \xd0\xb2\xd0\xb0\xd1\x80\xd1\x8b', '000000041', '41', None] So I've removed my python25, than installed in again from ports (Darwin) and installed again from ports pysqlite... and hurra!!! No error with 8-bit bytesstrings. The fun was, that my pysqlite version was more then 2.1.3. %) pysqlite kills me %) soon as i need it only for tests, because in production we use postgresql. On Mar 15, 11:52 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > this appears to be a SQLite bug and I've created a ticket at: > > http://oss.itsystementwicklung.de/trac/pysqlite/ticket/256 > > On Mar 15, 2009, at 5:36 AM, GeertVc wrote: > > > > > > > Hi, > > > I have a problem following the DivingIn tutorial on > >http://elixir.ematia.de/trac/wiki/TutorialDivingIn. > > > I've posted a question about the problem (http://groups.google.com/ > > group/sqlelixir/browse_thread/thread/419fddeb4c70a3d2), but so far, no > > luck. > > > Since this is based on SqlAlchemy, I thought I'd give it a try here (I > > know this is cross-posting, but I would like to understand what's > > going wrong...). > > > Maybe someone over here knows the cause of my problem? > > > Any help much appreciated, since I'd really like to continue with this > > db in Python... > > > Best rgds, > > > --Geert --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---