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.
- Cedric
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
