I know it is not ideal, but I've solve the problem by changing the create_engine in pylons.database with: sqlalchemy.create_engine(uri, convert_unicode=True, **kwargs)
Thanks, Matt On Jun 12, 2:55 pm, MattQc <[EMAIL PROTECTED]> wrote: > Hello, > I was at my second step to learn pylons. So I tried the QuickWiki > tutorial there:http://pylonshq.com/docs/0.9.4/quick_wiki.html > > I get an SQL error when I try to execute queries like this one on an > Oracle database: > > sqlalchemy.exceptions.SQLError: (NotSupportedError) > Variable_TypeByValue(): unhandled data type unicode 'SELECT > pages_content, pages_title \nFROM (SELECT pages.content AS > pages_content, pages.title AS pages_title, ROW_NUMBER() OVER (ORDER BY > pages.rowid) AS ora_rn \nFROM pages \nWHERE pages.title > = :pages_title) \nWHERE ora_rn<=1' {'pages_title': u'FrontPage'} > > When I try the same query without the unicode type it is working with > such bind variable: > {'pages_title': 'FrontPage'} > > I saw that pylons doesn't support arguments (like convert_unicode) > yet. > So, how can we discard the unicode type conversion? > > Thanks, > Matt --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
