AES_DECRYPT - Returens Blob[empty]

--0-673845031-1295416973=:78547
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi,=0AMySQL (version 5.1.45 , windows based) AES_DECRYPT () function is not=
working =0Aproperly, If I removed Order by clause from the following =
query it works Fine. =0AIf I add order by it resulting blob[empty] value. =
=0A>> select=0AS.semyear as semester, S.part as part, =0AS.code as c=
ode, S.subject as Title,=0AAES_DECRYPT(R.cia, 'TEMPSTR') as cia,=0AAES_DE=
CRYPT(R.sem, 'TEMPSTR') as sem, =0AAES_DECRYPT(R.result, 'TEMPSTR') as resu=
lt,=0AR.exam, =0AR.regarr =0Afrom =0Aexamresults as R,=0Ag_subject as S =
=0Awhere S.code =3D R.code and=0AR.regno =3D 'A08BBD03'=0AOrder By S.semy=
ear, R.rank, S.code, R.regarr , R.exam Can i have advise Please?=0A=
=0AThank you.=0AVikram =0A
--0-673845031-1295416973=:78547--