Character data type

Official Content
This documentation is valid for:

Stores text values.

Definition

Character(M)

Where:
M
Specifies the length of the character, where the maximum length is 9999.

The length of a Character field is fixed, so that you cannot change the length you declared for that field when you created the table. All functions and operators can be applied to this data type.

The following table illustrates the maximum length tolerated by each DBMS and the conversion done by GeneXus according to the DBMS:
 

DBMS Length Conversion
Oracle 255 Char
DB2 Universal Database 255 Char
Informix 9999 Char
SQL Server 8000 Char
Access 254 dbText
DB2 for iSeries 320001 Char
DBF 254 Char
PostgreSQL 9999 Char

32765 in Genexus 15 Upgrade 10 or previous
The Character and VarChar data type Data types are similar, but differ in the way they are stored and retrieved.

See also

VarChar data type
Data types list





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