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.

Reply via email to