Re: [Bacula-users] Filename searching and case insensitivity

2011-04-11 Thread Kernel Panic
I think I understand but as the Filename column in the Bacula script is created with the BLOB data type then according to the documentation the lower() function does not work: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_lower It says I need to convert it into a non-binar

Re: [Bacula-users] Filename searching and case insensitivity

2011-04-09 Thread Dan Langille
On Apr 5, 2011, at 10:19 PM, Kernel Panic wrote: > On 6 April 2011 02:37, Dan Langille wrote: >> >> On Apr 5, 2011, at 9:31 PM, Kernel Panic wrote: >> >>> Hello everyone, >>> >>> Whilst trying to find a way of doing a case-insensitive search for >>> file, I found previous posts on the mailing

Re: [Bacula-users] Filename searching and case insensitivity

2011-04-06 Thread Rory Campbell-Lange
On 6 Apr 2011, at 02:37, Dan Langille wrote: > > On Apr 5, 2011, at 9:31 PM, Kernel Panic wrote: >> >> 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 >> m

Re: [Bacula-users] Filename searching and case insensitivity

2011-04-05 Thread Kernel Panic
On 6 April 2011 02:31, Kernel Panic wrote: > 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

Re: [Bacula-users] Filename searching and case insensitivity

2011-04-05 Thread Kernel Panic
On 6 April 2011 02:37, Dan Langille wrote: > > On Apr 5, 2011, at 9:31 PM, Kernel Panic wrote: > >> 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 ba

Re: [Bacula-users] Filename searching and case insensitivity

2011-04-05 Thread Dan Langille
On Apr 5, 2011, at 9:31 PM, Kernel Panic wrote: > 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

[Bacula-users] Filename searching and case insensitivity

2011-04-05 Thread Kernel Panic
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 startin