How to set max size for varchar?

[Former Member]

Hi, all.

I want to set a type like Varchar(max) in SQL Server.

How to do that in MAXDB?

Thanks.

[Former Member · Accepted solution]

Hi,

sorry, I am not familiar with this feature in SQL Server.

For MaxDB the maximum length for CHAR (n) ASCII is 8000, for CHAR (n) UNICODE is 4000,

for CLOB is 2GB.

There is not chance to restrict these maxima.

If you want to define your 'own' datatype, maybe the concept of DOMAIN (see reference manual --> Data Definition --> CREATE DOMAIN) may help.

If this does not answer your question, please help us by describing this SQL Server-feature.

Elke