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,
Tim
I saw the posts about SQLAlchemy updating an id when this is generated
by SQLAlchemy by setting Sequence() on the table's primary key Column,
but being an old Oracle hacker, I am generating the primary keys via
pre-insert triggers on the tables.
As SQLAlchemy is not selecting seq_name.nextval
I am using mixed case for my Elixir Entities in common with other
identifiers.
When these are passed though to SQLAlchemy, the table name is double-
quoted in generated SQL and the database is created with quoted table
names.
This does not matter with SQLite, which ignores quotes in this
this is not obvious)?
Thanks for your help,
Tim
On Apr 16, 5:35 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Apr 16, 2008, at 12:22 PM, Dr.T wrote:
Oracle however becomes case sensitive when quotes are used and if a
table is created with a quoted name, you must always quote references
to it thereafter
It is possible specify the name of a Foreign Key Constraint generated
by a foreign key column specification?
Looking at the documentation, the name parameter seems to refer to
an existing database FK constraint rather than specifying the name of
the generated constraint.
(My problem is that I