Sorry about that. I was trying to say, I have a query that is doing this:
query = meta.Session.query(Foo.id, Foo.name, func.hex(Foo.hash)) to get back the hex representation of a blob column. I'd really like to get back a base64 representation, without having to run a hex -> bytes -> b64 conversion on every row in the results. I'm stuck on mysql 5.1 atm, so I can't use func.to_base64(), to pick up the native mysql function. How hard would it be to add a method to the func package? Does anyone know of an example of doing this? thanks, --bill On Tue, Mar 20, 2012 at 1:28 PM, Bill Curtis <b...@beautylish.com> wrote: > I have q -- 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.