.sopm-File with VARCHAR without length limit

[schulmann]

Hi,

in an .sopm-File I want to specify a new db table with a column of type VARCHAR without a length limit.
The statement looks like "<Column Name="name" Required="true" Size="200" Type="VARCHAR" />".
Now I would like to eliminate the size.
Neither to remove "Size" completely nor 'Size="0"' works.
Thanks.

Claus-Dieter

[zzz]

Hello Claus-Dieter,

That's not possible but you can use large numbers.
You always keep the type as VARCHAR but if the size is 256–65535 the column will be created with the data type TEXT, 65536–16777215 will be MEDIUMTEXT, and everything larger than 16777215 will automatically be converted into LONGTEXT.

— Emin

[schulmann]

Hello Emin,

thank you.

Then I'll try it with a <CodeInstall>-Section.

Claus-Dieter