parsing/storing large text data
I have seen a lot of pre-cooked java forum packages on the net but I would like to code my own and hence need some support. I have expertise in databases and have designed the required schema. Now to start I would like to have some help on this issue:
In forums, eg this one, users may reply with long text inputs. What would be the best way to store them? One option is to use a Text field in the database which stores 65K characters. Another is to convert the large text to binary and store.
Pls tell if there is any other option, else how shall I about accomplishing the second one?