Troy Daniels wrote:
An update to this.
I cant vouch for this exact query - on my system it takes a looonnggg
time to finish due to the 2 million plus files recorded and I gave up
and canceled it, but the following simplified version worked:
mysql> select Name from Filename where LCASE(Name) = 'makedev';
+---------+
| Name |
+---------+
| MAKEDEV |
+---------+
1 row in set (1.15 sec)
So I dont understand why it wouldn't work in the other query - but I'm
not a MySQL Guru.
I am running MySQL Server 3.23.58 tho which could be the difference I
suppose.
Yes, I think that does make a difference. On this page:
http://dev.mysql.com/doc/refman/4.1/en/charset-binary-op.html
it notes that something is different about binary column types after v4.
Not sure I understand it enough to say what the difference is though!
Mark
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users