Thu, 24 Sep 2026
Login

Why is there a 20-character limitation on table names?

Confluence User - 04 Jan, 2020

MySQL's table name length upper limit is 64 characters, but when I use MySQL I still get the 20 character limitation. Why is that?

Also, is there a chance this limitation could be removed?

table;table-name;forms;database

3

Confluence User •
06 Jan, 2020 •
confluenceUser •
•
confluenceUser •

Hi, I believe the limitation is to ensure app compatibility across different database servers, for example older versions of Oracle have short character limits.

Confluence User •
06 Jan, 2020 •
confluenceUser •
1 •
confluenceUser •

20 char is limit at Joget level to ensure compatibility across all databases. When I design a Joget app on my mySQL based Joget, I can safely deploy into my customer's site who is using Oracle/MSSQL safely. I think this is a good move...

Confluence User •
25 Feb, 2024 •
confluenceUser •
•
confluenceUser •

Joget should have made this configurable in the Settings. In 2024 this limit is still 20 chars. Let the client decide what is good for them. This is a major issue for some.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How can I set dedicated datasource for each app ?
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Issue Saving AJAX Subform Data to Datalist in Joget
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print