While creating the table and its fields in the database, it creates an incorrect collation as follows. To try this, create any table and add fields in it. You can find the result from the databases folder under the .wappler folder. ( .wappler/targets/Production/databases/mappcc.json )
Also it would be nice to have collation and charset definition. I guess this important feature seems to have been forgotten.
What exactly is incorrect?
In the connection json file we list the available collations retrieved from your database to be used later in the tables for setting in advanced mode of the database manager.
actually yes, I think I didn’t explain well. I created a few tables and saw that the collation values of some tables were different. I cannot reproduce the issue. I saw this difference while checking with heidisql. I’ll let you know after I can reproduce the issue. (this problem may also be caused by heidisql, I’m not sure)
Wappler’s Database Manager creates new tables always with the default database collation, unless you specify different one in the advanced options.