search

sebasmonia / pyquebec

A Python package to create quick SQL queries from the console.
https://github.com/sebasmonia/pyquebec/wiki
MIT License
1 stars 0 forks source link

Schemas and Tables are "case sensitive" #10

Closed sebasmonia closed 8 years ago

sebasmonia commented 9 years ago

The query for the tables and columns, at least in MS SQL Server, returns elements just as they were created. Pypyodbc returns the column names in lowercase.

Maybe we should make everything lowercase?

Pro: Consistency Con: readability.

ferantivero commented 8 years ago

exactly as they were fetched from the DB, IMO

jmaltube commented 8 years ago

1$ 7#1$ $0 #4RD 70 R34D???

If not, why would lower case would be any worse?

lowercase ftw

jdecarli commented 8 years ago

As fetched from the DB. We don't know if the system consuming the DB requires the "casing"

sebasmonia commented 8 years ago

@ferantivero even if ita inconsistent with the names in the results?

@jdecarli I think the standard demands case insensitiveness

sebasmonia commented 8 years ago

2 votes to 1 to keep them as is.

Closing bug.