Hi,

I have database with a lot of tables and every table have a comment filed which is length up to 3000 characters. I would like to optimize those tables to smaller size (1000 characters) but firebird don't resize fields to smaller value even it is empty. How to solve this problem?

I need one more tip from firebird masters, is it smarter for me to use varchar fields with 1000 - 3000 length or text blob fields in case of performance and better work?

Thanks in advanced...