Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
firebird-automations opened this issue Jun 20, 2008 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

Modified by: @asfernandes

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

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

Usage:

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

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Commented by: @asfernandes

Attribute name changed to NUMERIC-SORT

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants