I need some help down here.
1. My SQL Field - Last name, first name , middle name (are encrypted field using AES)
2. I need to do display all the rows using PAGING on my C# Application.
3. Order by Last Name, First Name then Middle Name.
However, i cant do so as i cant sort in Mysql as this field is Encrypted.
I had 700k records, will have run out of memory error if i select all records, start to decrypt and do a sorting.
View Complete Post