3 ms·
SQL
by jeletonskelly 11y ago
SQL
- justinlardinois 11y agoThis is definitely true, and why I had more than a few stumbles learning it after I was already an experienced programmer. Case insensitivity in string comparisons is a good example. It makes perfect sense to a non-programmer but is not at all what a programmer would expect.
- alayne 11y agoWhat case insensitivity are you referring to?
- defen 11y agoMySQL with default collation / locale / operators does case insensitive string comparison IIRC
- justinlardinois 11y agoExactly. Something like 'P' = 'p' evaluates to true.
- eru 11y agoYou might like Functional Relational Programming. See http://lambda-the-ultimate.org/node/1446 http://lambda-the-ultimate.org/node/1446