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