The content field for custom databases in Pages is a MEDIUMTEXT column, so it can hold ~16,7 million characters. The character count includes also the HTML tags you can't see while using the editor: bold format, italic, font size, colors, etc.
I believe older versions used TEXT until a certain point, though. If that is your case, a TEXT column can hold only 65k characters.