how to set a default data type for fields in database when use forms?

 
1
0
-1

Hi, community¡  when we use forms to create fields in the tables, by default the system add fields in long text format,  how can I change this behavior in order to use Var chart format instead?

regards

Fabian

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Fabian Barrera

      You can change the database column size or data type using a database manager utility such as SQLyog, via the ALTER TABLE and MODIFY commands together to make the change, example from LONGTEXT to MEDIUMINT or VARCHAR.

      Remember to stop Joget tomcat before altering your database to prevent database reads and writes during your ALTER command execution. Do perform thorough testing on your development server before implementing on the live server.

      For every Joget installation of your app in every server using the new column data type, you need to remember to ALTER the data type change in every Joget database from LONGTEXT to <newdatatype>. Importing your app into a new Joget server will automatically default back all "c_" columns to LONGTEXT data type.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Thanks Friend¡

          CommentAdd your comment...