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
- Apple OAuth Scopes
Hi Hi, I've configured sign in with apple and this is the response i'm getting from apple once i've signed in. I cant find anywhere I set scopes. I remember se...
- Sign In With Apple OAuth Help
Hi All! I've got a flutter & appwrite app which Im trying to use sign in with apple for. I already have sign in with google working and the function is the sam...
- [SOLVED] OAuth With Google & Flutter
Hi all, I'm trying to sign in with google and it all goes swimmingly until the call back. I get a new user created on the appwrite dashboard however the flutte...