LongVarChar data type

Official Content
This documentation is valid for:

To store long text descriptions.

Syntax

LongVarChar(M, N)

Where:
M
Maximum length value. If the length assigned to the attribute is greater than what is actually supported by the DBMS then the DBMS' maximum will be used.

N
Average length value.

Definition

The following table illustrates the properties used to define the Data Type:

Maximum length property
Average length property
Enable national language support property
Value range property
Initial value property
Picture Properties Group

 

Description

The LongVarChar data type is designed to store a large number of characters, for example maintaining a large text with customer information.

The Maximum Length of LongVarChar attributes or variables is the following: 33,563,648. The maximum Average Length is 255.

For values higher than 9,999, you can only define as maximum, values that are a multiple of 1Kb. If, for example, you enter the value 10,000, the field is actually defined with size 10,240 (the multiple of 1Kb immediately higher).

The following document states which data types are used for each DBMS: Data types of attributes in the DBMS

Notes

LongVarChar attributes cannot be:

  • Part of an index (this also means that they cannot be part of a primary key).
  • Defined as redundant.

GeneXus does not control that the size defined by the developer is supported by the DBMS. This implies that if in GeneXus an attribute is defined with size AttSize and the maximum value supported by the DBMS is MaxDBMS, with MaxDBMS being smaller than AttSize, and you try to insert a chain of characters of size StrSize, with MaxDBMS smaller than StrSize, and this is smaller or equal to AttSize, an error will occur at execution time, depending on the DBMS.

See also




Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.