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

Discussion in 'ASP .Net' started by The Crow, Dec 28, 2005.

  1. The Crow

    The Crow Guest

    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).
     
    The Crow, Dec 28, 2005
    #1
    1. Advertisements

  2. 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" <> wrote in message
    news:%23Y$eX%...
    > 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).
    >
     
    Peter Rilling, Dec 28, 2005
    #2
    1. Advertisements

  3. The Crow

    The Crow Guest

    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.
     
    The Crow, Dec 28, 2005
    #3
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. luna
    Replies:
    1
    Views:
    14,117
    Kevin Spencer
    Feb 6, 2004
  2. luna
    Replies:
    1
    Views:
    7,046
  3. Vishal
    Replies:
    1
    Views:
    853
    Steve C. Orr [MVP, MCSD]
    Dec 21, 2004
  4. Claudio Grondi
    Replies:
    3
    Views:
    547
    Claudio Grondi
    Mar 22, 2005
  5. =?Utf-8?B?Z29yaWxsYQ==?=
    Replies:
    1
    Views:
    998
    Masudur
    May 25, 2007
  6. Hal Vaughan
    Replies:
    4
    Views:
    924
    Hal Vaughan
    Jan 14, 2008
  7. Alexey Verkhovsky

    [Ruby Forum] Forum digest by email

    Alexey Verkhovsky, Sep 22, 2004, in forum: Ruby
    Replies:
    0
    Views:
    598
    Alexey Verkhovsky
    Sep 22, 2004
  8. Chris Hulan
    Replies:
    2
    Views:
    784
    Steven D'Aprano
    Apr 3, 2013
Loading...