Developing Portable Applications > Developing Portable Applications > Achieving Transparency and Portability > Enterprise Access Behaviors > Length Specifiers
Was this helpful?
Length Specifiers
Enterprise Access requires character length specifiers on string data types (char(n), varchar(n), nchar(n) and nvarchar(n)) when used in DDL statements. If length is not specified, it will trigger a gateway syntax error. This differs from the Ingres DBMS, which defaults the length to 1 if it is not specified.
For example, the following statement fails:
create table mytable (col1 varchar)
By specifying a length for varchar(n), the statement works:
create table mytable (col1 varchar(1))
Last modified date: 08/22/2022