Hello.
How does your application connect to MySQL server (MyODBC or
Connector/Net)? What versions of MySQL Server and Connector do you
use?
"M DR" <dhmderuitersql@stripped> wrote:
> Hi,
>
> I'm currently using AES Encryption to encrypt some of my data (using it in a
> ASP.NET application). As this is all text strings, I was wondering if there
> is a possibility to automatically have the output in the ASP.NET String
> format instead of the system.byte[] format, so I won't have to format every
> item out of the database.
>
> For example a query like:
>
> SELECT AES_DECRYPT(Fieldname, '123') FROM Tablename ORDER BY Field_ID
>
> returns the system.byte[] format, while I'd like to see the String format as
> output. Is this possible?
>
> Btw, the strange thing is, when I don't include a ORDER BY (or GROUP BY)
> function, it already returns a String format. Any idea how this is possible?
>
> Thanks,
>
> Martin
>
> _________________________________________________________________
> MSN Webmessenger doet het altijd en overal http://webmessenger.msn.com/
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
