oracle - SQL Server sorting with ASCII Control Chars and Collations

Question

We are in the process of adding SQL Server 2019 data storage and retrieval to a legacy application that was coded for Oracle.

We use varchar columns that contain ascii text and sometimes also hold non-printable ascii chars, ASCII 3 is a prime example. We use the non-printable ascii chars as a separator between data and special configuration information. All characters are in the 1-127 ascii range.

In Oracle when we query data from these fields the sorting/indexing performs as expected, sorting fields that only have text first, followed by fields with identical text + ascii control codes last.

As an example, consider this column sort from Oracle:

column1
SomeText
SomeText<ascii 3>(((

question from:https://stackoverflow.com/questions/65852998/sql-server-sorting-with-ascii-control-chars-and-collations

Answer 1

Waitting for answers