1,数据:ub_articles
ArtFullCode
--------------------
22-1-10-10
22-1-10-09
2-2-11-012,SQL:
select ArtFullCode from ub_articles
ORDER by ArtFullCode 3,结果:
ArtFullCode
--------------------
22-1-10-09
2-2-11-01
22-1-10-104,为什么结果不是:
ArtFullCode
--------------------
22-1-10-09
22-1-10-10
2-2-11-01或
ArtFullCode
--------------------
2-2-11-01
22-1-10-09
22-1-10-10
ArtFullCode
--------------------
22-1-10-10
22-1-10-09
2-2-11-012,SQL:
select ArtFullCode from ub_articles
ORDER by ArtFullCode 3,结果:
ArtFullCode
--------------------
22-1-10-09
2-2-11-01
22-1-10-104,为什么结果不是:
ArtFullCode
--------------------
22-1-10-09
22-1-10-10
2-2-11-01或
ArtFullCode
--------------------
2-2-11-01
22-1-10-09
22-1-10-10
select ArtFullCode from ub_articles order by ArtFullCode COLLATE Chinese_PRC_BIN
结果就成了
ArtFullCode
--------------------------------------------------
2-2-11-01
22-1-10-09
22-1-10-10(3 行受影响)