Re: Dash in sort value is skewing sort
Mike,
I just stumbled upon this thread, as I'm just now finally getting around to converting my DB's to MSSQL. On the one message you said:
From researching the forum and internet, I have come to determine that the Collate setting best for VDF/DF
is SQL_Latin1_General_CP1_CI_AS
But then in a later messageto Vicki, you said:
I found that SQL_Latin1_General_CP1_CS_AS matches how the embedded sorting works.
So now, I'm totally unsure which one to pick, when newly converting a database. All of my indexes are Uppercased, but I do have some dashes in those fields, and use looping extensively for updating.
I'm still on VDF 16 with CK 6.0.0.32.
Thanks,
Leslie
Leslie L. Stewart
Director of IT
Aggregate Management, Inc.