If you're using PostgreSQL the size is essentially unlimited. With MySQL it is 16 MB.
There are few exceptions to this rule where we may be using a 64 KB column if you're on MySQL.
I wouldn't recommend storing that much data however. If you're using Elasticsearch, the custom data on the User will be indexed, and Elasticsearch will eventually hit a limit as well.