Post reply

Howto Save a large amount of text in SqlServer DB?

  • November 22, 2004 at 9:45 am

    #102288

    Hi. I have a table called [Content]: ContentID,Content

    The field Content is set to 'text'.

    When I try to save the content I have in a webpage, more precisely inside a <textarea> I get this text like: string s=mytextArea.Text and save this in the [Content] table.

    When I select the saved text it just shows me 'part' of the saved text.

    I believe its because SqlServer threats it in a different way and probably truncates it in a pre-determined size.

    I would appreciate receiving some tips regarding this issue.

    Regards,

    KenA.

    Kindest Regards,

    »»» KenA

  • November 23, 2004 at 7:35 am

    #531212

    SQL Query analyzer has a default setting which controls the output you see from a query. If you select Tools -> Options from the menu bar and then click on the Results tab, you will see a setting that controls the number of characters returned per column.

  • November 23, 2004 at 7:42 am

    #531214

    See, if this helps:

    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]

  • November 23, 2004 at 9:05 am

    #531246

    Ok ... that config solved my problem! Thanks

    Kindest Regards,

    »»» KenA

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

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