how forum post's stored in database? (which data type)?

T

The Crow

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).
 
P

Peter Rilling

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?
 
T

The Crow

yes maybe not and i decided to go sraightforward and choosed nvarchar (as my
primary language is turkish and i want unicode support for searching). but i
just wondered how they successed unlimited lenght.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top