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
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
- Need personalized consulting on your specific app and customizations? Book an online call with me here.
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