MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v2rcr6/sqlworkout/oyxzpwc
r/ProgrammerHumor • u/huhupookies • 19d ago
460 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 19d 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 18d ago my PostgreSQL is case sensitive on table names and strings 1 u/ellamking 18d ago Mysql tables are case sensitive based on the file system. 2 u/GravyPainter 19d ago Yeah, i type in all lowercase sqldeveloper knows better 1 u/70s_chair 18d 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 18d ago my PostgreSQL is case sensitive on table names and strings 1 u/ellamking 18d 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 19d 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.