Shawn Church wrote: > > > On Wed, Sep 24, 2008 at 7:37 PM, Michael Bayer <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > we can of course add more functions to the list of "known" functions > such as ifnull() (it would be best if ifnull() is a SQL standard > function, I'm not sure if it is). > > > Not sure this will work for IFNULL since it's type depends upon the > runtime arguments. I missed the func type_ argument when I read the > documentation. That is a good solution for the general case of > specifiying the type when it cannot be determined from the function or > the function arguments. In fact I'm going to use it any time the type > is not obvious. > > For what it is worth the following patch modifies ResultProxy to convert > strings to unicode if convert_unicode == True. It 'fixes' my example > and test/testall.py still passes.
Adding ?charset=utf8&use_unicode=1 to your MySQL connection URL is a much easier way to get Unicode back from all DB access. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---