FEAT: Adding lowercase for global variable by jahnvi480 · Pull Request #187 · microsoft/mssql-python
- Document the new
lowercaseglobal in the package docs/readme.
Documentation Enhancement Needed:
The new lowercase global variable should be documented in the package documentation to help users understand its behavior and impact.
Recommendation:
Add documentation for the lowercase global to the main package README. This should include:
Purpose: Explain that lowercase controls column name case sensitivity in Row attribute access
Default behavior: lowercase=False (case-sensitive, preserves original column names)
When enabled: lowercase=True enables case-insensitive attribute access by converting all column names to lowercase
Performance note: When enabled, adds slight overhead during cursor description initialization for column name processing
Usage Example:
`
import mssql_python
Enable case-insensitive column access
mssql_python.lowercase = True
Now all these work regardless of actual column casing:
row.column_name # Works
row.COLUMN_NAME # Works
row.Column_Name # Works
`
Add a new "Configuration Options" section to the main package README, or include it in an existing "Usage" section if one exists.
This documentation will help users understand when and why they might want to enable this feature, especially those migrating from other database libraries that have different case sensitivity behaviors.