T044, "Multiplier P"

The length limit of large object types, like clob and blob, accept the factor p, for peta in the basis of two (2⁵⁰).

CREATE TABLE ... (
 s CLOB(1P)
)

Related

Implied Features

• T043, "Multiplier T"

• T041, "Basic LOB data type support"

  • T046, "CLOB data type"

Mandatory Features

• E021-01, "CHARACTER data type (including all its spellings)"

Optional Features

• F421, "National character"

• T062, "Character length units"

• T081, "Optional string types maximum length"

Implementation-defined Elements

• ID068, "The implicit large object length when large object length is omitted."

• IL042, "The maximum lengths for character string types and binary string types."

Normative References

The optional feature T044, "Multiplier P" is defined in ISO/IEC 9075-2:2023. It first appeared in 2008.

You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail , Bluesky or RSS to gradually catch up and to keep modern-⁠sql.com on your radar.

About the Author

Can I use...

News

The Standard

Concepts

Features

Use Cases