Sorting issue with space

[aneesh (Arcadix Infotech Pvt.Ltd)]

After Sort I am getting result like this

Adfgsdh
Bhdfaf
Dbsdf
Z Edfghf
Mkjldfhd
Zdhgj

Word Z Edfghf came on wrong place. When I removed space it came on proper place

ElasticsearchResponse objElasticResponse = objClient.Search(strIndex, strType, @"
{
""from"": 0,
""size"": 10000,
""sort"" :[
{ ""Name"": { ""order"" : ""asc"" , ""missing"" : ""_last"" , ""unmapped_type"" : ""long""} }
],
""query"": {
""bool"": {
""must"": [
],
""should"":[
]
}
}
}");

[warkolm (Mark Walkom)]

What's the mapping on the field?

[aneesh (Arcadix Infotech Pvt.Ltd)]

"Name" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
},
"fielddata" : true
}

[warkolm (Mark Walkom)]

Use the Name.keyword field and you should be ok.

[aneesh (Arcadix Infotech Pvt.Ltd)]

ElasticsearchResponse objElasticResponse = objClient.Search(strIndex, strType, @"
{
""from"": 0,
""size"": 10000,
""sort"" :[
{ ""Name.keyword"": { ""order"" : ""asc"" , ""missing"" : ""_last"" , ""unmapped_type"" : ""long""} }
],
""query"": {
""bool"": {
""must"": [
],
""should"":[
]
}
}
}");

Query like this

[aneesh (Arcadix Infotech Pvt.Ltd)]

Hi.

Sorting is still not coming as expected

AbcEdf
Abc Zgdfg

if sort above, Second word is coming first because of that space

[aneesh (Arcadix Infotech Pvt.Ltd)]

Hi.

Sorting is still not coming as expected

AbcEdf
Abc Zgdfg

if sort above, Second word is coming first because of that space

[Christian_Dahlqvist]

That is as far as I can see the correct and expected ASCII sorting order. I am not sure if it is possible to override this.

[aneesh (Arcadix Infotech Pvt.Ltd)]

Ok. Anyway Thanks Christian_Dahlqvist.