Looking at the tables I think your right on the varbinary 8 & 16. Are you making the TEXT fields varchar(8000)? or optimizing.
I've installed piwik to understand where you are coming from, but I need to tidy it up as I'm getting jquery error (as usual, no big deal) and my zend library is located under the php directory.
But, at least I can understand the MySQL table structure.
Cheers
David

--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> p51b.mustang wrote:
> > I may be interested, I have resisted modifying (fixing) FB in ZendX because if there was an upgrade to Zend and expecially integration of FB into properly I would be in a patch mode:-)
>
> Made good progress so far. Not only is piwik storing site information nicely
> from half a dozen of my sites, the user interface seems to be fairly functional
> with just the odd error. Now to document what I've had to do to convert the
> piwik code base :)
>
> MAIN problem turned out to be the use of case sensitive field names and once I'd
> reset them to all lower case .... along with the mod to Zend'd Firebird driver
> to RETURN lower case field names, the bulk of the stuff just worked. Although I
> still managed to miss one which took a little longer to spot.
>
> The one thing I DO need to 'unbodge' is the data that MySQL was storing as
> BINARY(8) fields. I've simply killed off the hex2bin and bin2hex so I get a
> CHAR(16) field, but in theory I should be able to simply store as a BIGINT. I'm
> not sure that it matters that much for visitor id's, and the ip address needs
> extending to handle V6 anyway.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>