GaryAllan

Results 152 comments of GaryAllan

Hello @jnorell VARCHAR length specifies characters and not bytes. I think this is a utf8mb3 vs utf8mb4 issue. The 4 byte Chinese characters will need utf8mb4. This is the 1st...

Hello @jnorell Can you check your mysql defaults? The below is from the official MariaDB docker images ``` root@mariadb:/etc/mysql# grep -r utf /etc/mysql /etc/mysql/mariadb.conf.d/50-server.cnf:# utf8 4-byte character set. See also...

Hi @jnorell I've done some reading and utf8 in MySQL is well.... a horror show. See https://mathiasbynens.be/notes/mysql-utf8mb4 I think what everyone expects utf8 to be is actually `utf8mb4 COLLATE utf8mb4_unicode_ci`...

Hi I'm not sure what the reported issue is here. It looks like the search found no results.

If you set $debugging=true; in config.php you should get extra information on why it failed.

Hi, Do you have "Resolve DNS names" enabled in settings? DNS lookup timeout/issues could be to blame

This error is generated by the PDO library. Do you have a limit on the number of concurrent MySQL sessions? The only bug I can think of is database sessions...

Hi @Barsug If NULL/blank values are valid (the default value has to be a valid value) then the field is optional. "Required"=NULL/Blank values are not allowed, even as a default.

You probably also want an ENUM here rather than a SET. A SET can have multiple selections ('undefined' and simultaneously 'AlwaysOn' selected). An ENUM can have only one of the...

The default should be a valid option if Required is enabled. Add and empty option. ENUM Required: enabled Size/Length: '','undefined','Always On',... Default: ''