If it were me, I'd use 1 for LONGVARCHAR and 0 for LONGVARBINARY.

The original plan was that positive values were for system
defined blob types and negative values were the user name
space. 0 is undefined. 1 is Text, 2 is BLR, 3 ACL (access
control list), 4 RANGES, 5 SUMMARY, 6 FORMAT, 7 TRANSACTION_DESCRIPTION
8 EXTERNAL_FILE_DESCRIPTION



Regards,

Ann
www.ibphoenix.com
We have answers.