1. Ruslan Zasukhin
  2. Announcements & News
  3. 火, 5月 02 2017, 08:02 AM
  4.  メールで購読
Hi ValentinaDB Developers,

A few days ago a question appeared via support to make String field (containing numbers) sort records using those numbers.

By default the examples { test-1, test-10, test-2, test-24, test-7, test-27, test-17 } will be sorted as:

test-1
test-10
test-17
test-2
test-24
test-27
test-7

If for that field collation option you set Numeric Ordering to be ON, then sorting will be sorted as:

test-1
test-2
test-7
test-10
test-17
test-24
test-27
参照
  1. http://valentina-db.com/docs/dokuwiki/v7/doku.php?id=valentina:products:vstudio:help:schema_editor:property_inspector:field_method
コメント
There are no comments made yet.


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories