ID069, “The implicit character maximum length when character maximum length is omitted.”

CREATE TABLE … (
  s VARCHAR(…)
)

When omitting the maximum length of a character string, the implementation-defined limit is typically above a billion but sometimes as low as 1.

1. Supports varchar(max) as reasonably long length limit

Related

Affected Features

• E021-02, “CHARACTER VARYING data type (including all its spellings)”

• F421, “National character”

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 implementation-defined element ID069, “The implicit character maximum length when character maximum length is omitted”, is specified in ISO/IEC 9075-2:2023. It first appeared in the 2023 revision.