Uwe,

> So what do you suggest Helen I use to make best use of space if I would
> want to create a log file of all actions in a system happening and the
> values that were changed where the larges value is +- 100 bytes big ,
> VARCHAR(100) filed. but most values changed will be in the range of 20 to
> 30 bytes ?

If you want to do that in a general way then create a VARCHAR
column with a length of the largest possible value for all
Non-BLOB related columns, that means, everything except BLOBs
go into that VARCHAR column. [VAR]CHAR, Integer, Smallint,
Numeric, Decimal, ...

If you want to log BLOB column valueas as well, then create
a BLOB column for that.


HTH,
Thomas Steinmaurer
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com

- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation