Data Types

Results 1 to 2 of 2

Thread: Data Types

  1. #1
    Join Date
    Dec 1969

    Default Data Types

    I need to store text in a SQL 2000 database. The varchar data type gos to 8000 characters. My fields wont exceed 4000. Should I use varchar and set the limit, then check the lenght of the field (from the form) before I try to enter it, or just use a text data type?<BR>Thanks<BR>Greg

  2. #2
    Join Date
    Dec 1969

    Default RE: Data Types

    always use the smallest possible datatype. if your fields won&#039;t exceed the length of varchar, use varchar and check in your code.<BR><BR>j

Posting Permissions

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