Entity field query issue to correctly sorting my results I have field order in my content type, in which I have assigned numeric values for my 21 products in order to sort them in ascending order. Results should be displayed like the below order as I expect:


1
2
3
4
5
6
7
8 and so on to 21.


But products are displaying in the following order:


1
10
11
12
13
14
15 up to 19 then 
2
20
21
3
4
5
6 up to 9


I dont know why. Here is my snippet.

 $query = new EntityFieldQuery();
 $query-&gt;entityCondition('entity_type', 'node');
 $query-&gt;fieldOrderBy('field_order', 'value', 'ASC');
 $query-&gt;entityCondition('bundle', 'my_content_type');
 $query-&gt;pager(8,0);
 $query-&gt;propertyCondition('status', 1);
I can't make Molot's comment an answer, but I'll post one for posterity (and to close out this question). 

The issue involves your data field type, integer vs. string. When the field is a string, sorting in SQL query will place the rows in lexicographic order, where the first character value is given precedence. When the field is an integer, sorting in SQL query will place the rows in numeric order, where the entire value of the number is used.