Results 1 to 10 of 10

Thread: Long text in sql server

  1. #1
    Join Date
    May 2007
    Posts
    1

    Long text in sql server

    i have a table in sql server, i want to insert a long text for a field. that long text like a file's text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values. reply me if u have answer

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Take look at writetext in books online.

  3. #3
    Join Date
    Jun 2007
    Posts
    1

    Smile Solution for storing Long Text

    Hai

    Try to declare the Data type as "CLOB". It will store 1 Billion upto Characters.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Does sql server have that data type?

  5. #5
    Join Date
    Jun 2007
    Posts
    2

    varchar (max)

    If this is SQL 2005, try varchar (max)

  6. #6
    Join Date
    Jun 2007
    Posts
    6

    Large text in MSSQL

    text and ntext are types with a maximum length of 2GB.

  7. #7
    Join Date
    Jun 2007
    Posts
    6
    Quote Originally Posted by vlrgee
    Hai

    Try to declare the Data type as "CLOB". It will store 1 Billion upto Characters.
    Would "1 Billion" be a 1 followed by 18 zeros or a 1 followed by 12 zeros here?

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    That's 1g, but sql doesn't have clob data type.

  9. #9
    Join Date
    Jun 2007
    Posts
    6

    A character large object (CLOB) is a text,ntext, or image in SQL parlando

    A character large object (CLOB) is a text,ntext, or image in SQL parlando. So SQLServer does support CLOB it is called text (for 8 bit ascci) or ntext (for 16 bit unicode). It can store up to 2 Gigabyte of information which is 2,147,483,647 ascci characters or 1,073,741,823 unicode characters. If you'd like to store binary data there is the image type which stores up to 2,147,483,647 bytes.

    hope this helps

  10. #10
    Join Date
    Jul 2007
    Posts
    5
    try this one

    Create table TextInsert
    (Text1 Text)

    GO

    CREATE PROCEDURE Text_Insert (@Document as text ) AS

    Insert Into TextInsert values( @Document )

    GO

    exec Text_Insert 'i have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values.
    reply me if u have answeri have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values.
    reply me if u have answeri have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values.
    eply me if u have answeri have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values. reply me if u have answer
    i have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values. reply me if u have answer
    i have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values. reply me if u have answer
    i have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values. reply me if u have answer
    i have a table in sql server, i want to insert a long text for a field. that long text like a files text.please tell me what is the data type for that field. i tired ntext and text data type but i cant insert long text values. reply me if u have answer
    '

Posting Permissions

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