pymssql 2.0.0 (beta) doesn't need max_identifier_length = 30 anymore

Issue #2347 resolved
Former user created an issue

From my limited testing, freetds 0.9.1 + pymssql 2.0.0 (beta) finally provide a viable solution to run application code on Linux against MSSQL database. Even unicode works great. My only problem is that the current max_identifier_length = 30 set for pymssql<2 is a bit too low. Maybe we can bump this while dropping support for pymssql<2 in a later SQLAlchemy major release?

Comments (3)

  1. Mike Bayer repo owner

    we can also have max_id_length switch itself when pymssql > 1 is detected, that would be easy enough. we might also look into cleaning up dbapi_version and all that to resemble pyodbc more closely. I know I go way past the 30 char mark almost immediately with the constraint naming conventions we have (fk_parent_table_name_colname_referenced_table_name :) )

  2. Log in to comment