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 <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
>>To: mysql@lists.mysql.com
>>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" <[EMAIL PROTECTED]> 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
>> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
>>/_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED]
>>
>
> _________________________________________________________________
> 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
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED]
_________________________________________________________________
Speel online games via MSN Messenger http://messenger.msn.nl/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]