Results 1 to 3 of 3

Thread: Best datatype ?

  1. #1
    Join Date
    Nov 2001
    Posts
    36

    Angry Unanswered: Best datatype ?

    One of my users wants to store 20,000 characters in a field. The worst part is he wants to be able to search on that field and he is expecting it to have atleast 10,000 records.

    Please let me know what is the best thing to do in this case.

    Thanks.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    I suspect your only choice is to use a text data type. To handle the searching I would setup full text search. Read up on these in Books Online and post back with questions.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Nov 2001
    Posts
    36
    Thanks Paul.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •