Error Messages Associated with SQLSTATE 22001

This topic lists the errors associated with the SQLSTATE 22001.

SQLSTATE 22001 Description

ERRCODE_STRING_DATA_RIGHT_TRUNCATION

Error messages associated with this SQLState

ERROR 2991: Date 'string'string too long for type string(value)

ERROR 3426: Float 'string'string too long for type string

ERROR 3589: Integer 'string'string is too long for type string(value)

ERROR 3605: Interval 'string'string too long for type string(value)

ERROR 4208: Numeric 'string' is too long for type string

ERROR 4315: Padded octet length (value) exceeds the value octet limit

ERROR 4604: Result (value characters) exceeds the field width (value)

ERROR 4800: String of value octets is too long for type string(value)

ERROR 5004: Time 'string'string too long for type string(value)

ERROR 5024: Timestamp 'string'string too long for type string(value)

ERROR 5032: Timestamptz 'string'string too long for type string(value)

ERROR 5035: Timetz 'string'string too long for type string(value)

ERROR 5417: Value too long for type character varying(value)

ERROR 5418: Value too long for type character(value)

ERROR 7401: Date 'string' too long for buffer of length (value)

ERROR 7431: Interval 'string' too long for buffer of length (value)

ERROR 7568: Time 'string' too long for buffer of length (value)

ERROR 7569: Timestamp 'string' too long for buffer of length (value)

ERROR 7570: TimestampTz 'string' too long for buffer of length (value)

ERROR 7571: TimeTz 'string' too long for buffer of length (value)

ERROR 8276: Type string(value) is too short to hold UUID values, need at least value

ERROR 8682: String of value octets is too long for type string(value) for column string

ERROR 9067: String with length value is too long for type string(value)