Hello everyone, Whilst trying to find a way of doing a case-insensitive search for file, I found previous posts on the mailing lists that instructed me to use the sqlquery function in bacula. As a test I wanted to search for files with zfs in their name and then with ZFS in the name. After starting up bconsole and entering sqlquery mode I did the following:
USE bacula; SELECT * FROM Filename WHERE name LIKE '%ZFS%'; SELECT * FROM Filename WHERE name LIKE '%zfs%'; Although the commands worked, they only returned case-sensitive matches, despite MySQL's documentation stating that pattern matching is case-insensitive by default: http://dev.mysql.com/doc/refman/5.5/en/pattern-matching.html Can anyone help me? Thanks. ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
