String Length

The number of bytes that are required to hold the string in the database after Content Manager OnDemand converts the string to the code page of the server.

String conversion between code pages might result in either an increase or decrease in the length of the string when data is loaded on the server. For example, the client might require two bytes to display a double-byte character, yet the server might require three bytes to store the character in the database. In this example, Content Manager OnDemand increases the string length to a size that is sufficient to hold the data that you have selected. If you expect that other possible values for the field might require more space than Content Manager OnDemand calculated, you can override the length by typing a different number in the space provided.

If the String Type value is Fixed, the maximum length of the string field is 254 bytes. All values that are stored in the field contain the same number of bytes. When you load data, if an index value contains fewer bytes than the string length, Content Manager OnDemand adds one or more spaces to the right of the index value to fill the database field. The additional spaces become part of the field value.

If the String Type value is Variable, the maximum length of the string field is 2000 bytes.