ressie.Littel answered on October 10th 19 at 14:24
bad it is clear that for some reason but Firebird, accordingly, to sort the results when the result can not, because the index must be constructed by the true value of the field and not on hash.
there are 3 solutions:
1. calculated in the regiment we will decode your value and sort in the program (on client): DataTable.Filter:='FIELDNAME',DataTable.Filered:=true;
2. nezamorachivayas for encryption (because your encoder is single-handedly will be revealed as a thoughtful Pro), and stored everything in plaintext
3. will work almost as well as you have a slow current on the server (to write UDF for decryption on the server)
nikita.Stracke answered on October 10th 19 at 14:26
there is still a 4th option: to write an external function for FB, decrypts the value and work with it directly in the database.
There is a fifth option. Decrypt into a temporary table and work with it. After completion of the work the table to kill.