Post reply

inserting more than 8000 characters in a field

  • February 14, 2005 at 6:57 am

    #362019

    I want to insert more than 10,000 characters in a field in Sql server. I am able to insert 8000 characters in the field in SQlserver. Now I want to create a field to insert 15000 characters in a single field in the Sqlserve. what should be the data type of the field to achieve the same functionality

  • February 14, 2005 at 7:36 am

    #542046

    This should help you:

    http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • February 14, 2005 at 11:47 pm

    #542193

    you can use text or ntext filed

     from the bol

    ntext

    Variable-length Unicode data with a maximum length of 230 - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered. The SQL-92 synonym for ntext is national text.

    text

    Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes.




    My Blog: http://dineshasanka.spaces.live.com/

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

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