Two identical values detected as different values when doing queries or group by due to hidden or invisible charactersSummary Sometimes when copying and pasting from certain applications, hidden characters can be pasted, causing the value in the database to be different from what is visually seen in the field, making queries appear to be returning incorrect data. Related LinksThere is currently no platform setting or capability to automatically remove "invisible" characters when pasted into a field. Our dev team is typically asked to retain the exact content that customer's supply. If necessary, you can implement rules to automatically remove characters. If data is primarily manually input, then updating the BR to validate only allowed characters or sanitize the input are options that can be used to address this.