The sort order of characters in MicroStrategy is different from ASCII standards. The MicroStrategy sort order of characters affects:
| • | The order of files and folders in MicroStrategy Developer and MicroStrategy Web |
| • | The order of ascending and descending sorts of alphanumeric values in MicroStrategy reports |
The sort order described below is for English locales only. The sort order may be different in different locales.
The table below lists the non-printable characters which are first in the sort order. All these characters are equal to each other, so the final sorting order is determined by which character is retrieved from the data warehouse first.
ASCII characters that are non-printable characters are listed in the tables below with their character representation. For example, a backspace is represented as BS.
NULL
|
SOH
|
STX
|
ETX
|
EOT
|
ENQ
|
ACK
|
BEL
|
BS
|
SO
|
SI
|
DLE
|
DCL
|
DC2
|
DC3
|
DC4
|
NAK
|
SYN
|
ETB
|
CANC
|
EM
|
SUB
|
ESC
|
FS
|
GS
|
RS
|
US
|
DEL
|
The table below lists the sort order of characters in MicroStrategy. The order goes from left to right and top to bottom. For example, the top left table cell (TAB) is the beginning of the sort order, the cell to the right of that (LF) is next in order, and the bottom right cell (Z) is the end of the sort order.
TAB
|
LF
|
VT
|
FF
|
CR
|
‘
|
^
|
_
|
-
| |
,
|
;
|
:
|
!
|
?
|
.
|
‘
|
“
|
(
|
)
|
[
|
]
|
{
|
}
|
@
|
*
|
/
|
\
|
&
|
#
|
%
|
+
|
<
|
=
|
>
|
|
|
~
|
$
|
0
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
a
|
A
|
b
|
B
|
c
|
C
|
d
|
D
|
e
|
E
|
f
|
F
|
g
|
G
|
h
|
H
|
i
|
I
|
j
|
J
|
k
|
K
|
l
|
L
|
m
|
M
|
n
|
N
|
o
|
O
|
p
|
P
|
q
|
Q
|
r
|
R
|
s
|
S
|
t
|
T
|
u
|
U
|
v
|
V
|
w
|
W
|
x
|
x
|
y
|
Y
|
z
|
Z
|
Thank For sharing Valuable Information
ReplyDeleteMicrostrategy Training
Microstrategy Online Training
Top Online Casinos for Real Money 2021 - WURRIEGE
ReplyDeleteDiscover worrione the best real money online casinos for you in 2021, plus septcasino where 메리트 카지노 쿠폰 to play and win real money. Play casino games online!