Cedric Tefft wrote:
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.
Hmm... yeah, I tried that, but it didn't work for me, whereas the
CONVERT() strategy does:
mysql> select Name from Filename where LCASE(Name) = 'makedev';
Empty set (1.03 sec)
mysql> select Name from Filename where CONVERT(Name using
latin1)='makedev';
+---------+
| Name |
+---------+
| MAKEDEV |
+---------+
1 row in set (1.85 sec)
I am using mysql 5.0.18, though, like you, I don't know why that should
make a difference.
Thank you so much for your help on this. I've tested the suggestions
above on my system, which uses MySQL v4.1 and found that the LCASE
doesn't work but the CONVERT does work. As I am just getting into
production with bacula, my database isn't large enough yet to make any
speed conclusions. This is a great help. Thanks again.
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
