Failure 3798: A column or character expression is larger than the max size

Database

Failure 3798: A column or character expression is larger than the max size

Hi All,

I am trying to create a table on Terdata installed on UNIX machine. However, the table creation fails when the maximum size of VARCHAR datatype is set to more than 32000. Below is the error message:

---------------------------------------------------------------------
Failure 3798 A column or character expression is larger than the max size.
---------------------------------------------------------------------

The same create table statement works fine when executed on TerData Express Edition (v12) on Windows.

Can any one let me know whether there is any limitation set for datatye size in TerData or the same depends on TeraData settings.

Thanks in advance,
Swaroop
1 REPLY

Re: Failure 3798: A column or character expression is larger than the max size

Check the default CHARACTER SET defined for database or user in which you are creating a table. Is it single byte or multibyte. You can override it in CREATE TABLE, in COLUMN specification. Try this, it should work.

CREATE TABLE TestDB.abc
(
colA VARCHAR(64000) CHARACTER SET LATIN
)