how about func.convert(literal_column("UUID() USING utf8"))

Bryan wrote:
>
> I want to use MySQL's uuid() function to create default values for a
> column.  I need to convert the output of uuid() to utf-8 however, so
> the full function in SQL looks like this:
>
> CONVERT(UUID() USING utf8)
>
> I can't set this as a column default using the func.function() syntax,
> because python complains about invalid syntax when it encounters the
> USING part.
>
> How can I set this chain of functions as a default? Is there some sort
> of SQL literal function that I could use?  I tried using the literal
> object, but it of course escapes whatever the value is which does not
> work.
>
> Bryan
>
> >
>


--~--~---------~--~----~------------~-------~--~----~
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