Dr.T wrote:
> I want to make my oracle 10g queries case insensitive.
>
> To do this, I need to execute:
>
> alter session set NLS_SORT=BINARY_CI;
> alter session set NLS_COMP=LINGUISTIC;
>
> at application initialization.
>
> How might I do this via SQLAlchemy?
>
> Thanks for your help,
class MySetup:
def connect(self, dbapi_con, con_record):
dbapi_con.execute('alter session set NLS_SORT=BINARY_CI')
dbapi_con.execute('alter session set NLS_COMP=LINGUISTIC')
engine = create_engine('oracle:...', listeners=[MySetup()])
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
