Issue Details (XML | Word | Printable)

Key: CORE-1945
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Philippe Makowski
Votes: 1
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Custom attribute for collation to sort numbers in numeric order

Created: 20/Jun/08 08:11 AM   Updated: 08/Nov/09 06:58 PM
Component/s: Charsets/Collation
Affects Version/s: None
Fix Version/s: 2.5 Beta 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
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

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 22/Jun/08 04:10 PM
Documented in doc/README.intl (NUMERIC attribute).

Usage:

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

Adriano dos Santos Fernandes added a comment - 24/Jun/08 09:48 PM
Attribute name changed to NUMERIC-SORT