Hello,
Anyone know how to change the SQL collation without losing any data?
If I understand it correctly, it's more about query response than data loss. If you change the collation, it's possible that you'll see an impact on the data retrieved. It's really something for a DBA to answer, than for us THWACKsters to advise.
Hmm Could this affect how items are searched and reported upon in SWQL/web interface. I am noticing some odd results with underscores and hyphens/dashes in results against orion 2023.1. It looks like the two characters are treated as the same by swql now.
