Question
Turkish character problem when sorting grid data
Hi,
I have problem at sorting data in grid, if column data start with Turkish character like "Ş,İ,Ö,Ü,Ç etc".
Has anybody encounter with the same problem?
***Updated by moderator: Lochan to add Categories***
sort in PRPC internally mostly uses compareTo() method and it might be the reason for wrong string compare for turkish characters. Need to check if special handling is done for non English letters or not.
Generally for the Turkish Alphabet abcçdefgğhıijklmnoöprsştuüvyz and applying sort with compareTo() will result in abcdefghijklmnoprstuvyzçöüğış
Yes, I've come across a similar problem before, in some fashion.
When you perform this sort, is this going back to the database to retrieve results or is this simply sorting in Java. That is, if you trace this with DB Query enabled do you see the SQL.
And if this is a DB sort, I assume that the SQL is adding an "order by" clause. Can you please confirm which database type you are using.
