Re: INSERT encrypted data
Hello. What data type are you using to store the result of AES_DECRYPT? Please, send the CREATE statement for your table. sharif islam wrote: > On 1/19/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > >>Hello. >> >>What doesn't work? In case you want more help please, provide the >>results you want obtain from your query and CREATE statement for you table. > > > Sorry for not being clear. The data is getting saved as NULL instead > of being encrypted. > > > > >>sharif islam wrote: >> >>>mysql> insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003'); >>>Query OK, 1 row affected (0.00 sec) >>> >>>mysql> select * from ccard >>>-> ; >>>+--+-+ >>>| crypt| expire | >>>+--+-+ >>>| )\u\u\u\u\u\u\u | 10/2003 | >>>| )\u\u\u\u\u\u\u | 10/2003 | >>>| )\u\u\u\u\u\u\u | 10/2003 | >>>| )\u\u\u\u\u\u\u | 10/2003 | >>>+--+-+ >>>4 rows in set (0.00 sec) >>> >>>why doesn't this work? >> >> >>-- >>For technical support contracts, goto https://order.mysql.com/?ref=ensita >>This email is sponsored by Ensita.NET http://www.ensita.net/ -- 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: INSERT encrypted data
On 1/19/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > What doesn't work? In case you want more help please, provide the > results you want obtain from your query and CREATE statement for you table. Sorry for not being clear. The data is getting saved as NULL instead of being encrypted. > sharif islam wrote: > > mysql> insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003'); > > Query OK, 1 row affected (0.00 sec) > > > > mysql> select * from ccard > > -> ; > > +--+-+ > > | crypt| expire | > > +--+-+ > > | )\u\u\u\u\u\u\u | 10/2003 | > > | )\u\u\u\u\u\u\u | 10/2003 | > > | )\u\u\u\u\u\u\u | 10/2003 | > > | )\u\u\u\u\u\u\u | 10/2003 | > > +--+-+ > > 4 rows in set (0.00 sec) > > > > why doesn't this work? > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INSERT encrypted data
Hello. What doesn't work? In case you want more help please, provide the results you want obtain from your query and CREATE statement for you table. sharif islam wrote: > mysql> insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003'); > Query OK, 1 row affected (0.00 sec) > > mysql> select * from ccard > -> ; > +--+-+ > | crypt| expire | > +--+-+ > | )\u\u\u\u\u\u\u | 10/2003 | > | )\u\u\u\u\u\u\u | 10/2003 | > | )\u\u\u\u\u\u\u | 10/2003 | > | )\u\u\u\u\u\u\u | 10/2003 | > +--+-+ > 4 rows in set (0.00 sec) > > why doesn't this work? -- 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]
