was that perhaps the implementation of encode/decode changed,
but googling so far has been to no avail.
My second thought was that perhaps there was a problem when we dumped the data
from the 4.x server and imported it to the 5.x server. The old 4.x server is
gone, so I cannot verify whether
Why doesn't mysql support gzip for COMPRESS/UNCOMPRESS and only zlib
For network applications zlib is a lot less compatible than gzip.
For example I could send gzip'd content directly from the database within a
larger gzip'd stream.
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco
> Is it possible to update all my encoded data with another password?
Yes. Example for the encoded/decode functions:
UPDATE table
SET pass_colum = encode(decode(pass_column, old_password), new_password);
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi,
Is it possible to update all my encoded data with another password?
Thanks for your advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Friday 04 February 2005 03:31 pm, John Trammell wrote:
> In my version of MySQL (4.1.9), your sample code generates an error:
>
> mysql> select decode(encode("foo"));
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for
---+
| foo |
+---+
1 row in set (0.00 sec)
> -Original Message-
> From: Jeff Smelser [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 04, 2005 2:14 PM
> To: mysql@lists.mysql.com
> Subject: Re: ENCODE & D
On Friday 04 February 2005 11:00 am, shaun thornburgh wrote:
> Apparently not!
>
> mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM
> DATA_TABLE_PID_1_DESC_137;
Is it so hard to read directions?
select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137;
This assumes
You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near '(
> CSV_DATA_ENC_FORENAME, "test_password" ) FROM DATA_TABLE_PID_
> mysql>
>
> Any ideas?
>
>>From: Jeff Sm
_DATA_ENC_FORENAME, "test_password" ) FROM DATA_TABLE_PID_
mysql>
Any ideas?
From: Jeff Smelser <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: ENCODE & DECODE
Date: Fri, 4 Feb 2005 10:20:14 -0600
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
> I have a table
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
> I have a table where users upload various data items via a web site. Some
> fields in the table are named DATA_ENC... to denote that the data should be
> encrypted uusing the encode function. This all works fine, however when I
> come
Hi,
I have a table where users upload various data items via a web site. Some
fields in the table are named DATA_ENC... to denote that the data should be
encrypted uusing the encode function. This all works fine, however when I
come to selecting the data from the table I would like to be able to
I'm using encode/decode with PHP to crypt my database.
Until now was OK, but I one string, and the MySQL return the string this
(without the []...):
[Oõ#M¼ô«~àý~ªÔ"bë ÿ9S" Z ]
The fact is I can't insert this encode string into MySQL table! My select:
select decode(
12 matches
Mail list logo
