James Harper wrote:
I just threw together some MS SQL (because that's what I've got in front
of me) code that sort of does what you want, but not in a way that could
be used in a query (you'd have to put it in a user defined function,
which is easy enough to do), and being MSSQL it won't work as
Mark Nienberg wrote:
Mark Nienberg wrote:
I'd like to write an SQL query to extract some information from the
bacula catalog including file dates. I see from the bacula
developers guide that the File table has a field named LStat that
is defined as File attributes in base64 encoding. I
Cedric Tefft wrote:
Mark Nienberg wrote:
I'd like to write an SQL query to extract some information from the
bacula catalog including file dates. I see from the bacula
developers guide that the File table has a field named LStat that
is defined as File attributes in base64 encoding. I
James Harper wrote:
Do you want to deal with it in the query (harder), or in the code
that
processes the query (easier)? Are you asking what Base64 is, or do
you
know already and would just like some help doing something useful
with
it from within the SQL language?
My hope was to
Hi,
There was thread a couple of weeks back about the fact that bacula uses
a slightly different algorithm to the standard base64 one.
Would that apply in this case and would it account for the confusing
output received by Mark?
Just a thought - could be completely off the mark.
Troy.