Solved: DB length of the key of table ZZZ is too large (>7...

Former Member · ‎2009 Jul 14

Hi Experts,

I am creating a custom table with 10 fields in which 5 fields are primary key fields with each field length 120 characters. I have created and saved the table but cannot activate it because of the following error:

DB length of the key of table ZZZ is too large (>788)

please help me to how do I create the custom table with the above credentials.

Thanks-

Ramesh.

Sandra_Rossi · ‎2009 Jul 14

maybe it's because the size is expressed in bytes, and each character is 2 bytes? 5 key fields of each 120 characters would be 1200 bytes. Could you try with 3 (720 bytes) and 4 (960 bytes) key fields to see when it works?

Former Member · ‎2009 Jul 14

Can you paste here how you created your table?

Regards

Sandra_Rossi · ‎2009 Jul 14

maybe it's because the size is expressed in bytes, and each character is 2 bytes? 5 key fields of each 120 characters would be 1200 bytes. Could you try with 3 (720 bytes) and 4 (960 bytes) key fields to see when it works?

Former Member · ‎2009 Jul 21

got the solution by myself

Sandra_Rossi · ‎2009 Jul 21

Please help others by giving the solution or at least a little feedback, as per forum rules of engagement

Former Member · ‎2012 Oct 23

Hi Ramesh,

I am in same situation "DB length of the key of table ZZZZZ is too large (>780)" . Can you please help me on how you resolved this.

Regards,

Krishna M.

wol · ‎2012 Oct 23

Hello,

I would suggest not to have such big keys. Usually (and meaningful) one can build a technical key with a number range or guuid.

Is much lighter to handle by the db.

Regards,

Stefan