Max number of fields in Class?

Michael_S
Senior Member
Beiträge: 160
Registriert: Mi 4. Feb 2004, 02:39
Wohnort: London / UK
Kontaktdaten:

Max number of fields in Class?

Beitragvon Michael_S » Fr 1. Mai 2015, 15:18

Hi,

It looks like there's a limit on the number of fields a Class can hold, in the one I'm working on I can only add 24 fields?

Is this the case and if so can the limit be changed to allow more fields.

Regards,

Michael.
Production Area
London, UK
http://productionarea.com

mokraemer
Senior Member
Beiträge: 3619
Registriert: So 8. Aug 2010, 01:23
Wohnort: Mainz

Re: Max number of fields in Class?

Beitragvon mokraemer » Fr 1. Mai 2015, 15:51

the limit is set by the database and depends upon your field types, field length, the database version and the database encoding (uft-8 consumes more space than iso codes)
webEdition-Kern-Entwickler

Michael_S
Senior Member
Beiträge: 160
Registriert: Mi 4. Feb 2004, 02:39
Wohnort: London / UK
Kontaktdaten:

Re: Max number of fields in Class?

Beitragvon Michael_S » Fr 1. Mai 2015, 16:07

mokraemer hat geschrieben:the limit is set by the database and depends upon your field types, field length, the database version and the database encoding (uft-8 consumes more space than iso codes)
Hi mokraemer,

Yes, I was just looking at the db and got the following error message ... I will have to look at the data to adjust the field lengths:
MySQL hat geschrieben:#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
Thanks,

Michael.
Production Area
London, UK
http://productionarea.com

Michael_S
Senior Member
Beiträge: 160
Registriert: Mi 4. Feb 2004, 02:39
Wohnort: London / UK
Kontaktdaten:

Re: Max number of fields in Class?

Beitragvon Michael_S » Fr 1. Mai 2015, 16:20

It would be good to have some feedback in the Class editor when you reach the limit of the table. I will add this as a feature request.

Michael.
Production Area
London, UK
http://productionarea.com

mokraemer
Senior Member
Beiträge: 3619
Registriert: So 8. Aug 2010, 01:23
Wohnort: Mainz

Re: Max number of fields in Class?

Beitragvon mokraemer » Fr 1. Mai 2015, 20:14

for your problem you can change some of the columns to textarea which results in a text-column or change the length of some fields.
webEdition-Kern-Entwickler


Zurück zu „DB / Object Module“

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 5 Gäste