> A value record would essentially be an array of bytes as defined in > Value.getStream(). In other words the integer value 123 and the string > value "123" would both be stored in the same value record. More > ...
Storing all values as a binary field will prevent access to the content using standard database tools. You won't be able to look at the values in the database without starting Jackrabbit. If the data ever needs to be transformed (migration between application releases, consistency fixes, etc.) the SQL that has to be written will be complex. In addition to having to work with vertically stored data, you now also have to know how to convert a value to its binary representation. E.g. you cannot work with native SQL dates but have to work with hexadecimal strings. Johan Stuyts
