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
.sopm-File with VARCHAR without length limit
-
- Znuny wizard
- Posts: 471
- Joined: 20 Nov 2011, 16:08
- Znuny Version: 6.5.4
- Real Name: Schulmann
.sopm-File with VARCHAR without length limit
Znuny6/Debian/ESXi
-
- Znuny superhero
- Posts: 890
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: .sopm-File with VARCHAR without length limit
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
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
Free and premium add-ons: German | English
-
- Znuny wizard
- Posts: 471
- Joined: 20 Nov 2011, 16:08
- Znuny Version: 6.5.4
- Real Name: Schulmann
Re: .sopm-File with VARCHAR without length limit
Hello Emin,
thank you.
Then I'll try it with a <CodeInstall>-Section.
Claus-Dieter
thank you.
Then I'll try it with a <CodeInstall>-Section.
Claus-Dieter
Znuny6/Debian/ESXi