Hi,

When I run process, the Chinese character, which I write in TextField or TextArea, can't display correctly in form ( just display"??" ). I suppose it is a bug in V3.

Thanks.

  • No labels

3 Comments

  1. Tiensoon

    Can you share with us a screenshot?

    1. Sean.Fung

      Hi Tiensoon, I have uploaded the screenshot.

      1. Tiensoon

        Hi Sean,

        Is this a database you created yourself?

        The problem with your database is, the default character set is not set to UTF8. So, new form table automatically created by Form Builder is set with non-UTF8 character set. The following screenshot shows a sample of the issue you are facing.
        The default database installed together by Joget Workflow v3 installer is already set to UTF8 character set by default.

        Thus, what you can do is, alter the default character set of jwdb and the affected app_fd_ tables using the following MySQL commands:

        mysql> use jwdb;

mysql> ALTER database jwdb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql> ALTER TABLE `app_fd_crm_account` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;