On Oct 10, 2009, at 3:43 AM, Yo'av Moshe wrote: > Any ideas? > I still don't understand why the query is failing even when I'm > using a unicode object.
whats the error ? "EOF in multi-line statement" ? thats not a SQLAlchemy error message. what happens when you try SQLA 0.5.6 (perhaps there was some quirk regarding encoding that was fixed) ? a different / latest version of your DBAPI (perhaps your DBAPI is misunderstanding a character as a newline ) ? try SQLite with the same statement ? (what database are you using ?) > > Yo'av > > 2009/10/8 Yo'av Moshe <bje...@gmail.com> > Thanks, I didn't know about that awful IPython bug... > > I checked, and apparently my website is already doing the SA query > with a unicode object and not with a string one, so I think that > it's not the u'' thing (it's true that I forgot it in my console > testing, though). > What you showed about IPython explains why it didn't give me any > result when running in IPython with the unicode object - since it > wasn't really a unicode object. > > So again - I *am* querying SA with a unicode object, and still, it > fails the first time and works the second time. > > Yo'av. > > 2009/10/7 Wolodja Wentland <wentl...@cl.uni-heidelberg.de> > On Wed, Oct 07, 2009 at 07:55 -0700, Yo'av Moshe wrote: > > See what I mean here (it's me running the same query twice in > > IPython): http://paste2.org/p/457059 > > > > What can cause this behavior?! I can't think of anything! I guess > that > > one of my users has uploaded some article with some invalid utf8 > code, > > but should that kill the query? and how come it doesn't kill the > > second one? and what can I do to avoid it? > > In addition to the bug Mike pointed out to you I want to introduce you > to my favourite bug this year: > > https://bugs.launchpad.net/ipython/+bug/339642 > > If you run into unicode issues with IPython it is wise to check the > 'python' behaviour before development code against this bug. > > kind regards > > Wolodja Wentland > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (GNU/Linux) > > iQIcBAEBCAAGBQJKzMesAAoJEIt/fTDK8U78OTsP/jLC/OHMy7SqyM4T1OswUsfL > 7V4JXjvxk7xSRUaUwWSqbi4FHYPUDVQ3iFD4czVxmqBXeClW8gxJBXCLpYjisXNR > yXiDurakbeHG5FxrJEstYK9S2ZCM5uAx/aFy8PdT6rf7UO6XAi6nJ7xxQaMx4JMX > XoA4oU1HsyOh8a0eg8NkmpMVJxeeZxr4DjlfLmXosMEpysG3d+mdq9SkKfKXGEsS > t8PQqJDw8uLS+XdMmVLuwK6RtHV+ojNkH/FBQ6qfMGJEFWleeh2cKxiBoNTqOKlg > sf9PznO/63HrswpeUJb8gfPs3tq7Mxa9DJzhgBc0U3toRg2VPjQTASXDc4PYqsJd > K+WT/vbhpy34VDTABEPdD1DAxgit5H7AI+4DP6l5610qgWn1eNG6/jUi3mRIbojI > S24/3udaFhOY/0NNDcI5mMijr77sjMbTSizO8ITabef/o9IiYkob32+0pW3j3+aO > 0kK4SwWtoJ4qWwFsOD4ANcg5QjC9KcL2NlYe2gtWQhk3f9Fz9FbdfNzAptNvs94v > qic2JONG9aa/CWnqO6RjF0JUCXIcUyr3jr5eKsBh9mli6wd3RYJbRZXHAXBD7ypA > 3MPd2gX72zl6lCM+gJWgedK7c1YB6YbDcie+hGrj4m/0oHZeZdThbZJLymxvFRul > 0gr9vxE99ggO3sTq9XLr > =2y73 > -----END PGP SIGNATURE----- > > > > > -- > Yo'av Moshe > > > -- > Yo'av Moshe > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---