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
_______________________________________________
cps-users mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/cps-users
