MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:M DR Date:August 29 2005 4:30pm
Subject:Re: AES_DECRYPT output
View as plain text  
Hi,

Thanks for your answers,

What is according to you the bug? Should it always return a string format 
value? Or should it always return a system.byte[] format value?

And I guess you also refer to the strange behavior that it's different when 
adding an ORDER BY or GROUP BY, right?

Kind regards,

Martin


>From: Gleb Paharenko <gleb.paharenko@stripped>
>To: mysql@stripped
>Subject: Re: AES_DECRYPT output
>Date: Mon, 29 Aug 2005 11:27:08 +0300
>
>Hello.
>
>Your versions seem to be rather fresh. If you are able to make a
>reproducible test case you may want to report a bug at:
>   http://bugs.mysql.com
>
>
>
>"M DR" <dhmderuitersql@stripped> wrote:
> > Hi,
> >
> > I use the following to connect my application to the MySQL server:
> > Public ConnectionString As String = "driver={MySQL ODBC 3.51
> > Driver};server=localhost;uid=root;database=mydatabase"
> >
> > As you can see the version of the Connector is 3.51. I use MySQL version
> > 4.1.11.
> >
> > Martin
> >
> >
> >>From: Gleb Paharenko <gleb.paharenko@stripped>
> >>To: mysql@stripped
> >>Subject: Re: AES_DECRYPT output
> >>Date: Fri, 26 Aug 2005 17:14:28 +0300
> >>
> >>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
> >>
> >>
> >>
> >>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe:
> >>http://lists.mysql.com/mysql?unsub=1
> >>
> >
> > _________________________________________________________________
> > Gebruik MSN Webmessenger op je werk en op school
> > 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
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    
>http://lists.mysql.com/mysql?unsub=1
>

_________________________________________________________________
Speel online games via MSN Messenger http://messenger.msn.nl/

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