There is also varchar which has an 8K limit.
Each forum may have different requirements. If you are writing a forum
system, then just impose a limit yourself.
Realistically though, are people going to post more then 4K in a single
message?
"The Crow" <q@q.q> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...
im building an online forum system. ive inspected forum.asp.net forum's
and i think there is no limitation over how long a message could be. so i
wonder how messages stored in database. as i know nvarchar has a limit
about 4096 chars. and using ntext has searching limitations (when used
with LIKE operator).