I can save appointments as byte arrays, but I need to determine the max number of bytes for the database. The problem is that appointments can have reminders and the individual occurrences can me modified. So, is there a way to calculate the max size of the byte array needed to store an appointment with all its variancs using the Dave() method for an Appointment?
Does your DBMS offer a variable length binary type
SQL2005 and onwards offers VARBINARY(max) data type
It it difficult to speculate the size of your byte array's without first knowing what else you are storing in the appointment object. Simply write yourself that gets the maximum size of say 1000 sample/dummy appointments.
Once you get the MAX size from your test, just double it for good measure :)
RegardsAaron