Page 1 of 1

Inconsistent use of CHARSET in CREATE TABLEs

Posted: 2015-07-13 14:52
by davidc
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

Posted: 2015-07-16 12:10
by a.gneady
Hi David,

Thanks for reporting this issue. We'll inspect and fix it as soon as possible.

Re: Inconsistent use of CHARSET in CREATE TABLEs

Posted: 2015-07-29 18:58
by winelab
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