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

Reply via email to