[CPS-Users] SQL Directory = Members directory?

[Joshua Kramer]

Olivier,

Thanks.  Actually, a VARCHAR specifies how data is stored in the 
database.  A VARCHAR only takes as much storage on disk as the actual 
data, where a CHAR always takes the field length even if the data is 
shorter than the field lenth.  So, one record in this table:

create table test (
	value1	varchar(128),
	value2	char(128)
)

where value1 = 'a' and value2 = 'b' will be 129 bytes, where 
value1='aaa' and value2=b' will be 132 bytes.  In short, you still need 
to specify a field length for all fields.  How can I tell, in a 
CPSSchema, how long the fields are?

Cheers,
-Josh