varchar data type issue

  • I am parsing a documnet and i am grabbing that document into a variable of datatype varchar. The document contains more than 8k(upto 30k characters) characters. So how can I handle this situation.How can I get that document into my local varchar variable.

    thanks.

  • You can't get it into a local variable for exactly the reasons you stated.

    Can you post some more detail on what, exactly, you're trying to do (i.e. what you're parsing, how, and for what purpose), and perhaps we can find a workaround?

    --
    Adam Machanic
    whoisactive

  • With the best workaround probably being the advise to do this at the client or use a staging table with a text column.

    But like Adam already said, without more information it's like a shot in the dark.

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

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

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