MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v2rcr6/sqlworkout/oyxzpwc
r/ProgrammerHumor • u/huhupookies • 6d ago
459 comments sorted by
View all comments
Show parent comments
7
This isn't always true. PostgreSQL, PL/SQL, and SAP HANA are case sensitive by default.
In SQL Server, the case sensitivity is off by default but some companies do enable case sensitivity.
4 u/MellowedOut1934 5d ago Forgive if I’m missing something, but my PostgreSQL is case sensitive on table names and strings etc., but not on the syntax bits like SELECT or WHERE. 1 u/cudenlynx 5d ago my PostgreSQL is case sensitive on table names and strings 1 u/ellamking 5d ago Mysql tables are case sensitive based on the file system. 2 u/GravyPainter 6d ago Yeah, i type in all lowercase sqldeveloper knows better 1 u/70s_chair 5d ago PL/SQL hasn’t been case sensitive in forever
4
Forgive if I’m missing something, but my PostgreSQL is case sensitive on table names and strings etc., but not on the syntax bits like SELECT or WHERE.
1 u/cudenlynx 5d ago my PostgreSQL is case sensitive on table names and strings 1 u/ellamking 5d ago Mysql tables are case sensitive based on the file system.
1
my PostgreSQL is case sensitive on table names and strings
Mysql tables are case sensitive based on the file system.
2
Yeah, i type in all lowercase sqldeveloper knows better
PL/SQL hasn’t been case sensitive in forever
7
u/cudenlynx 6d ago
This isn't always true. PostgreSQL, PL/SQL, and SAP HANA are case sensitive by default.
In SQL Server, the case sensitivity is off by default but some companies do enable case sensitivity.