CB 2.0 ideas discussions

11 years 1 month ago #141584 by darb
Replied by darb on topic Re:CB 2.0 ideas discussions
This is a big problem...

ndee wrote:

Hi,

I don't know if I or somebody else already mentioned it but please take a look on field creation. Most fields are added as VARCHAR(255) to database - even if you only have a telephon field or something like that. This leads to break MySQL (see forums) because it has a limitation of approx. 65000 bytes of VARCHAR per table. If you have UTF-8 kollation (needs 4 bytes for each CHAR, so this is 255 CHARS * 4 bytes = 1020) you waste more than 1000 bytes for a field which may only needs 10 chars.

As all fields are stored in #__comprofiler table this limitation is a problem if you have a few plans with own fields for each plan (cbsubs). We have only 3 different plans but with 50+ fields each and have to manually edit the colums manually quite often.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.131 seconds

Facebook Twitter LinkedIn