Skip to Content
0
Jan 11, 2023 at 03:23 PM

Report is not using ASCII rules to sort.

60 Views Last edit Jan 11, 2023 at 03:28 PM 2 rev

I have a report I have developed against and Oracle database and we are trying to sort this by name. I have these 2 names

A. N. INSURANCE and A+ INSURANCE

+ is ascii character 43 and . is ascii character 46.

When I run the query in sqlplus, A+ comes before A. but in the crystal report A. is coming before A+

How do I work around this so the query returns consistent results in both a sql editor and the crystal report?

I am using Crystal Reports 2016 support pack 9 Patch 4.