Sybase ASE 15.7 sort ordering
0
votes
1
answer
596
views
I have my sort ordering in Sybase as:
45 190 **altdict** - Alternate (lower-case first) dictionary ordering
Am I right that alternate means "aAbBcC..zZ" ordering?
What should I do to change ordering with "ORDER BY" as 'ABC..YZabc..yz' ? What sort ordering to choose?
Where may it be changed? In a session? In SQL statement?
as far as I know I need to change the whole server sort ordering and rebuilt indexes. But there are a bunch of databases with different owners and different users and it seems a bit extreme
Asked by Mikhail Aksenov
(430 rep)
Feb 6, 2020, 02:44 PM
Last activity: Feb 7, 2020, 05:04 PM
Last activity: Feb 7, 2020, 05:04 PM