this error is coming when i try to create two attributes with 10000 size each what seems to be the problem??
because Appwrite uses utf8mb4 charset, 10,000 chars = 40,000 bytes. 2 attributes = 80,000 bytes. The maximum row size in mariadb is 65,535 bytes: https://mariadb.com/kb/en/innodb-limitations/#:~:text=MariaDB%20imposes%20a%20row%2Dsize,file%20size%20limit%20of%202GB.
the solution is to use a bigger size so that the data isn't actually stored in the row, but a pointer is used. bigger than 16,383
Why would you need to use 10,000 characters if you don't mind me asking @Ansh 🤔
no no i do mind🤣
Recommended threads
- Disabling registration
Is it possible to disable registration in self hosted ?
- Relationship lists aren't showing
In flutter, when I perform a listRows function for my table which contains various relationships in addition to normal data, I am not getting the relationships ...
- coolify help
need some help when i updated the docker compose config on coolify to update appwrite to latest version my old versions project and organization was totally ina...