.sopm-File with VARCHAR without length limit

English! place to talk about development, programming and coding
Post Reply
schulmann
Znuny wizard
Posts: 470
Joined: 20 Nov 2011, 16:08
Znuny Version: 6.5.4
Real Name: Schulmann

.sopm-File with VARCHAR without length limit

Post by 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
Znuny6/Debian/ESXi
zzz
Znuny superhero
Posts: 888
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: .sopm-File with VARCHAR without length limit

Post by 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
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
schulmann
Znuny wizard
Posts: 470
Joined: 20 Nov 2011, 16:08
Znuny Version: 6.5.4
Real Name: Schulmann

Re: .sopm-File with VARCHAR without length limit

Post by schulmann »

Hello Emin,

thank you.

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

Claus-Dieter
Znuny6/Debian/ESXi
Post Reply