Yes, though only adding the `collate rtrim` definition to the column definition in the table will make indexes including the column "work properly" without modifying all the table data to remove the trailing space(s) ...
Yes, though only adding the `collate rtrim` definition to the column definition in the table will make indexes including the column "work properly" without modifying all the table data to remove the trailing space(s) ...