On Apr 25, 2007, at 12:26 PM, kap_ravi wrote:
> > Apparently there is some problem with the UNICODE data that sqlAlchemy > sends to oracle from the turbo gears framework. But I have tried the > same from the python command line with named parameters and its works > without any issues. > feeding in unicode strings requires that they be encoded into bytestrings first. this can be accomplished by either the usage of the Unicode type on your Column definitions, or by sending the flag convert_unicode=True to create_engine(). the default encoding for this flag is utf-8 which can be configured by the 'encoding' flag sent to create_engine(). additionally, when using Oracle, you have to ensure that the environment variable NLS_LANG is set appropriately, such as "AMERICAN- AMERICA.UTF8". --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---