Field lengths

[tommy]

Where can I find information about field lengths.

F.ex. What is the maximum length for a character field?

[eisefr]

I asked that question during my tailoring course.
The answer was: 'There is no limit'.

Don't know if it is true though.

[tommy]

Hmmm yes of course it makes sense to have a character field with NO carrige returns but unlimited in length??? :evil:

[fid509]

I've heard the same thing on my course. There is, like always, no limit :wink:
But I suspect you still have to consider the max recordsize in SC.

[pcasey]

ServiceCenter records have a total record size limit. Historically, this was 32k, although somebody may have found a way to work around this after I left.

The sum total size of all fields in a record, plus a small amount of record structure data, cannot exceed 32k. That 32k worth of memory, however, can be used up by any combination of fields.

Thus, 1 30k field is fine, as are 10 3k fields, or 100 300 byte fields.

The reason most commercial RDBMS systems cap the length of character fields e.g. char (255) or varchar(255) has to do with their system of disk blocking and physical storeage. P4 uses a different storeage mechanism and hence doesn't require you to specify field lengths individually, until you map out to an RDBMS that is.

[tommy]

In SC5 it is possible to define the record limit.