1. Global Deployment Guide
  2. Field Sizes by Database Platforms

Field Sizes by Database Platforms

When specifying new field sizes, be careful as to whether they must be given in bytes or in characters. Field size units will vary by the RDBMS vendor:

  • Oracle Database. Specify field sizes in characters (using character semantics).

  • IBM DB2. Specify field sizes in bytes.

  • IBM DB2 for z/OS. Specify field sizes in bytes.

  • Microsoft SQL Server. Specify field sizes in bytes.

Note: For more information about using IBM DB2 for z/OS, see Implementing Siebel Business Applications on DB2 for z/OS and Siebel Database Upgrade Guide for DB2 for z/OS.