> > 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 write a custom query to put in the query.sql file so I > could run it from bconsole, but if I have to I guess I could script > something independently to deal with the conversion.
The way to do that might depend on the backend... hmmm... something to think about. > > I've tried a number of online decoders (including the one you suggest) > and none of them returns anything that makes sense when I give it a > value like BEHwQV. As you say, I am expecting a big integer, but I get > back nonsense or an error message. That is what made me question > whether I was going about it completely wrong. At this point I am stuck > on the conversion. It does give you a big integer if that's how you want to interpret it, when I type in 'BEHwQV' in the 'BASE64' window and then click 'Decode', I get ' 04 41 f0 41' in the hex window. I might have my endian-ness around the wrong way here, but if I shuffle that around to '41f04104', and convert it to decimal, I get 1106264324. This should be somewhere early 2005 if interpreted as number of seconds since Jan 1 1970. James ------------------------------------------------------- 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&kid0709&bid&3057&dat1642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
