Estimating disk-space usage using LENGTH(BLOB)

2004-12-16 Thread Mike Moran
I'm currently trying to write a short SQL expression that will give me a rough estimate of the disk-space usage of a particular bunch of rows in a table. For table 'example': CREATE TABLE `example` ( `id` int(11) NOT NULL auto_increment, `blah` varchar(255) NOT NULL default '', `blah2` lon

Re: Definition of password hashing algorithm in 4.1.7

2004-12-15 Thread Mike Moran
Mark Matthews wrote: [ ... ] Mike Moran wrote: I've been looking into what algorithm MySQL 4.1.7 uses for password hashing/encryption, with a view to ascertaining how secure it is. Does it conform to any combinations of published Specs e.g. MD5/SHA-1/etc? [ ... ] Mike, MySQL-4.1.7 uses

Definition of password hashing algorithm in 4.1.7

2004-12-15 Thread Mike Moran
I've been looking into what algorithm MySQL 4.1.7 uses for password hashing/encryption, with a view to ascertaining how secure it is. Does it conform to any combinations of published Specs e.g. MD5/SHA-1/etc? I had a look at com.mysql.jdbc.Util#newHash() and #newCrypt() in Connector/J 3.0, but