.sopm-File with VARCHAR without length limit

English! place to talk about development, programming and coding
Post Reply
schulmann
OTRS wizard
Posts: 410
Joined: 20 Nov 2011, 16:08
OTRS Version?: 6.0.32
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
OTRS6/Debian/ESXi

zzz
OTRS superhero
Posts: 714
Joined: 15 Dec 2016, 15:13
OTRS Version?: 3.x–6.0.x
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 & ((OTRS)) Community Edition services: efflux.de | efflux.de/en/

Free and premium OTRS add-ons: German | English

schulmann
OTRS wizard
Posts: 410
Joined: 20 Nov 2011, 16:08
OTRS Version?: 6.0.32
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
OTRS6/Debian/ESXi

Post Reply