Post reply

Field Size Limit (Sql v7)

  • September 11, 2003 at 11:08 am

    #162358

    We are running an application using ASP for the front end, Sql v7 for databases. Alot of our data is just text and alot of it. We have run into a problem where one of my programmers has stated that Sql has a field size limit of 8K. Can anyone tell me if this is true and is there a fix for it in 2000?

  • September 11, 2003 at 9:06 pm

    #473845

    The limit for a varchar field is 8000, if you use the text datatype you can have 2,147,483,647 characters.

    Bear in mind that when you use the text datatype you can't use ordinary string manipulation functions. The text is treated as BLOBs. Have a read of 'BLOBs and OLE Objects' in Books Online.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 17, 2003 at 8:14 am

    #474645

    Keep in mind the limits are lower if you are using Unicode data.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply