Re: AES_DECRYPT output
I tried changing the status, but it seems only MySQL staff can do it (so the message says), so I can't do that. Any idea how it's possible to do so? From: Nuno Pereira [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Wed, 07 Sep 2005 12:19:01 +0100 I suppose that you have to change the status to Open, or people suppose that there aren't any changes. It would be nice that it would be tested in ASP.NET because it can be simply a problem with of type conversion in .NET, I haven't see the problem (and I don't work with .NET). M DR wrote: Hi, I have reported the bug a while ago, but it seems not all bugs are taken seriously. I reported it and one of the researchers couldn't replicate the problem, so I provided a sample project in ASP.NET where the problem can be seen very easily, but nobody reacted (probably because the status has been set to Can't repeat). See for the entry in the bugs database: http://bugs.mysql.com/bug.php?id=12872 Any idea how I can help fixing the problem nonetheless? From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Mon, 29 Aug 2005 23:15:26 +0300 Hello. And I guess you also refer to the strange behavior that it's different when adding an ORDER BY or GROUP BY, right? Yes, in my opinion, ORDER BY shouldn't change the column's type. M DR [EMAIL PROTECTED] wrote: 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 -- Nuno Pereira -- 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]
Re: AES_DECRYPT output
Hello all, It seems that you can't change the status from closed (or can't repeat) to another. The only hope you have is someone in the developing teem test your bug with the combination you used: MySQL + ASP.NET + MyODBC. But I continue to say that the problem is not in MySQL Server, maybe in MyOBDC, but probably in ASP.NET. Try to post it in the list win32.mysql.com so that anyone in the win32 area can help, and a developer see it, test it and has the same problem. M DR wrote: I tried changing the status, but it seems only MySQL staff can do it (so the message says), so I can't do that. Any idea how it's possible to do so? From: Nuno Pereira [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Wed, 07 Sep 2005 12:19:01 +0100 I suppose that you have to change the status to Open, or people suppose that there aren't any changes. It would be nice that it would be tested in ASP.NET because it can be simply a problem with of type conversion in .NET, I haven't see the problem (and I don't work with .NET). M DR wrote: Hi, I have reported the bug a while ago, but it seems not all bugs are taken seriously. I reported it and one of the researchers couldn't replicate the problem, so I provided a sample project in ASP.NET where the problem can be seen very easily, but nobody reacted (probably because the status has been set to Can't repeat). See for the entry in the bugs database: http://bugs.mysql.com/bug.php?id=12872 Any idea how I can help fixing the problem nonetheless? From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Mon, 29 Aug 2005 23:15:26 +0300 Hello. And I guess you also refer to the strange behavior that it's different when adding an ORDER BY or GROUP BY, right? Yes, in my opinion, ORDER BY shouldn't change the column's type. M DR [EMAIL PROTECTED] wrote: 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 -- Nuno Pereira -- 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/ -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AES_DECRYPT output
Hi, Like advised I posted the problem in the win32.mysql.com list as well. Still though, I'm not convinced that this is an ASP.NET problem. I say because I tested this problem without ASP.NET too, in the program MySQL-Front. The results there were the same as in ASP.NET, meaning the type was different if I added ORDER BY to the AES_Decrypt query... From: Nuno Pereira [EMAIL PROTECTED] To: mysql@lists.mysql.com CC: M DR [EMAIL PROTECTED] Subject: Re: AES_DECRYPT output Date: Thu, 08 Sep 2005 13:51:49 +0100 Hello all, It seems that you can't change the status from closed (or can't repeat) to another. The only hope you have is someone in the developing teem test your bug with the combination you used: MySQL + ASP.NET + MyODBC. But I continue to say that the problem is not in MySQL Server, maybe in MyOBDC, but probably in ASP.NET. Try to post it in the list win32.mysql.com so that anyone in the win32 area can help, and a developer see it, test it and has the same problem. M DR wrote: I tried changing the status, but it seems only MySQL staff can do it (so the message says), so I can't do that. Any idea how it's possible to do so? From: Nuno Pereira [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Wed, 07 Sep 2005 12:19:01 +0100 I suppose that you have to change the status to Open, or people suppose that there aren't any changes. It would be nice that it would be tested in ASP.NET because it can be simply a problem with of type conversion in .NET, I haven't see the problem (and I don't work with .NET). M DR wrote: Hi, I have reported the bug a while ago, but it seems not all bugs are taken seriously. I reported it and one of the researchers couldn't replicate the problem, so I provided a sample project in ASP.NET where the problem can be seen very easily, but nobody reacted (probably because the status has been set to Can't repeat). See for the entry in the bugs database: http://bugs.mysql.com/bug.php?id=12872 Any idea how I can help fixing the problem nonetheless? From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Mon, 29 Aug 2005 23:15:26 +0300 Hello. And I guess you also refer to the strange behavior that it's different when adding an ORDER BY or GROUP BY, right? Yes, in my opinion, ORDER BY shouldn't change the column's type. M DR [EMAIL PROTECTED] wrote: 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 -- Nuno Pereira -- 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/ -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Nieuw: Download nu MSN Messenger 7.0 http://messenger.msn.nl/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AES_DECRYPT output
Hi, I have reported the bug a while ago, but it seems not all bugs are taken seriously. I reported it and one of the researchers couldn't replicate the problem, so I provided a sample project in ASP.NET where the problem can be seen very easily, but nobody reacted (probably because the status has been set to Can't repeat). See for the entry in the bugs database: http://bugs.mysql.com/bug.php?id=12872 Any idea how I can help fixing the problem nonetheless? From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Mon, 29 Aug 2005 23:15:26 +0300 Hello. And I guess you also refer to the strange behavior that it's different when adding an ORDER BY or GROUP BY, right? Yes, in my opinion, ORDER BY shouldn't change the column's type. M DR [EMAIL PROTECTED] wrote: 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 -- 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] _ Direct antwoord op je vragen: gebruik 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]
Re: AES_DECRYPT output
I suppose that you have to change the status to Open, or people suppose that there aren't any changes. It would be nice that it would be tested in ASP.NET because it can be simply a problem with of type conversion in .NET, I haven't see the problem (and I don't work with .NET). M DR wrote: Hi, I have reported the bug a while ago, but it seems not all bugs are taken seriously. I reported it and one of the researchers couldn't replicate the problem, so I provided a sample project in ASP.NET where the problem can be seen very easily, but nobody reacted (probably because the status has been set to Can't repeat). See for the entry in the bugs database: http://bugs.mysql.com/bug.php?id=12872 Any idea how I can help fixing the problem nonetheless? From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Mon, 29 Aug 2005 23:15:26 +0300 Hello. And I guess you also refer to the strange behavior that it's different when adding an ORDER BY or GROUP BY, right? Yes, in my opinion, ORDER BY shouldn't change the column's type. M DR [EMAIL PROTECTED] wrote: 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 -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AES_DECRYPT output
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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AES_DECRYPT output
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]
Re: AES_DECRYPT output
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]
Re: AES_DECRYPT output
Hello. And I guess you also refer to the strange behavior that it's different when adding an ORDER BY or GROUP BY, right? Yes, in my opinion, ORDER BY shouldn't change the column's type. M DR [EMAIL PROTECTED] wrote: 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 -- 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]
Re: AES_DECRYPT output
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]