|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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
|
|
Description
|
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 |
Show » |
|
New Feature
Closed
Minor
Custom attribute for collation to sort numbers in numeric order
Usage:
create collation unicode_num
for utf8
from unicode
'NUMERIC=1';