1152 shaares
4 private links
4 private links
12 results
tagged
mysql
Aussi https://websitebeaver.com/php-pdo-prepared-statements-to-prevent-sql-injection qui à l'air plus complet
Erreur :
- Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8'
Faire :
- https://docs.nextcloud.com/server/17/admin_manual/configuration_database/mysql_4byte_support.html
- https://help.nextcloud.com/t/solved-syntax-error-or-access-violation-1071-specified-key-was-too-long-max-key-length-is-767-bytes/34740
Ne pas oublier d'enlever le mode maintenance
sudo -u www-data php occ maintenance:mode --off
mysql_secure_installation
Utilisez utf8mb4_unicode_ci
general ou unicode_ci ?
https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci/766996#766996