List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 26 2005 2:14pm
Subject:Re: AES_DECRYPT output
View as plain text  
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



Thread
AES_DECRYPT outputM DR26 Aug
  • Re: AES_DECRYPT outputGleb Paharenko26 Aug
    • Re: AES_DECRYPT outputM DR29 Aug
      • Re: AES_DECRYPT outputGleb Paharenko29 Aug
        • Re: AES_DECRYPT outputM DR29 Aug
          • Re: AES_DECRYPT outputGleb Paharenko30 Aug
            • Re: AES_DECRYPT outputM DR7 Sep
              • Re: AES_DECRYPT outputNuno Pereira7 Sep
                • Re: AES_DECRYPT outputM DR8 Sep
                  • Re: AES_DECRYPT outputNuno Pereira8 Sep
                    • Re: AES_DECRYPT outputM DR8 Sep