Inconsistent use of CHARSET in CREATE TABLEs
Inconsistent use of CHARSET in CREATE TABLEs
Unlike for user defined tables, Appgin 5.41 does not add a CHARSET clause to the admin CREATE TABLE statements. This can result in different collations being used for the membership tables and the user defined tables. Errors can then occur in the generated code when joining membership tables with user tables to check permissions.
Re: Inconsistent use of CHARSET in CREATE TABLEs
Hi David,
Thanks for reporting this issue. We'll inspect and fix it as soon as possible.
Thanks for reporting this issue. We'll inspect and fix it as soon as possible.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: Inconsistent use of CHARSET in CREATE TABLEs
FWIW perhaps related:
After importing my first DB, I get 4 times this
Warning: htmlspecialchars(): charset `us-ascii' not supported, assuming utf-8 in C:\wamp\www\mgci01\datalist.php on line 1023
line 1023 contains:
$attr_id = htmlspecialchars($row[$FieldCountTV], ENT_QUOTES, 'us-ascii'); /* pk value suitable for inserting into html tag attributes */
As it is a warning I will ignore it.
hope it helps
After importing my first DB, I get 4 times this
Warning: htmlspecialchars(): charset `us-ascii' not supported, assuming utf-8 in C:\wamp\www\mgci01\datalist.php on line 1023
line 1023 contains:
$attr_id = htmlspecialchars($row[$FieldCountTV], ENT_QUOTES, 'us-ascii'); /* pk value suitable for inserting into html tag attributes */
As it is a warning I will ignore it.
hope it helps