Custom attribute for collation to sort numbers in numeric order [CORE1945]

[firebird-automations]

Submitted by: @pmakowski

Votes: 1

need a custom attribute for collation to create collaction that sort numbers in strings as numbers, not caracters example :
be abble to create a collation that could give the folowing order (ISO8859_1 or UTF8):
(C1 is CHAR(10))

select C1 FROM T1 ORDER BY C1 COLLATE FR_XX ;

C1

1
2
10
20
a1
a2
a10
a20

Commits: cd49fc3

====== Test Details ======

Result were checked on LI-T3.0.0.31827 (64x) and WI-T3.0.0.31836 (32x).
FB 2.5 (at least build 2.5.5.26870 what has been checked) produces WRONG
output for such rows when using collation CI_AI -- see comments inside .fbt

[firebird-automations]

Modified by: @asfernandes

summary: new custom attribute for collation => Custom attribute for collation to sort numbers in numeric order

[firebird-automations]

Commented by: @asfernandes

Documented in doc/README.intl (NUMERIC attribute).

Usage:

create collation unicode_num
for utf8
from unicode
'NUMERIC=1';

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Commented by: @asfernandes

Attribute name changed to NUMERIC-SORT

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done with caveats

Test Details: Result were checked on LI-T3.0.0.31827 (64x) and WI-T3.0.0.31836 (32x).
FB 2.5 (at least build 2.5.5.26870 what has been checked) produces WRONG
output for such rows when using collation CI_AI -- see comments inside .fbt