With MS SQL Server 2005 database created as case sensitive, sqlalchemy fails to access information schema

Issue #261 resolved
Former user created an issue

The module now uppercases all table and column names when accessing the INFORMATION_SCHEMA views. Tested on both case-sensitive and case-insensitive databases.

Comments (10)

  1. Former user Account Deleted

    (original author: ram) I'll take it...I believe I've got an installed version of 2005 around that I can create a case-sensitive DB on...

  2. Former user Account Deleted
    • removed status
    • changed status to open

    Thanks very very much for making this work: it was a major stumbling block, and I was scratching my head over how much code I'd have to change to patch it. I've added a patch against mssql.py@9a36771499c1428ab64af4a17cbbb83e54b4e85a to cover a few typos which slipped past the testing. Patched here at home (where I don't have MSSQL) altho' tested earlier at work where I do.

  3. Log in to comment