Error storing data: could not execute statement

 
1
0
-1

Hi, all

I've try Joget DX through docker, I use enterprise trial version 7.0.2 - build d2fbc9e.

When I create my own test app, I found that I cannot store any Chinese character in text field.

It shows "Error storing data: could not execute statement." when form saved, but it works fine when input English.

Same issue will not pumped out when I type Chinese character in Joget default sample apps.

====

I would like to know if this is mysql character set issue?

how can I fix it?

I can only access docker through terminal but have no idea how to login system, access mysql and to change default character set.

Thank you.

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      Hi, you can run a Docker MySQL container by specifying its character set according to https://hub.docker.com/_/mysql. Then you can link Joget on Docker to that MySQL container.

        CommentAdd your comment...
      1.  
        2
        1
        0

        Dear Thomas,


        Did you install Joget with Embeded DB?

        You can check in admin bar at Settings Menu then select Datasource and Profile Setting.


        You could refer this configurate then try to connect DB with your tools (I prefer MySQL Workbence for this case). You change DB property from this way.

        Hope his help


          CommentAdd your comment...
        1.  
          2
          1
          0

          Hi there, 


          Did you check database encoding format?

          Normally maria or MySQL was created database with "Latin" encoding but I think Chinese should be different Encoding (our language is Thai so we usually setup to "UTF8" encoding.


          Hope this help

          1. Thomas

            Hello Auttakorn

            Thanks for your reply.

            Yes, I know it should probably encoding issue, but I have no idea how I can fix it through Joget DX panel or docker command line terminal.

            I'm now use Joget DX by docker image.  Not install database and main program separately by myself, so I have no idea how to fix it.

            Can you share your experiences about how to change default database character set?

            Thank you.

          CommentAdd your comment...