Member Avatar for AsinuS

Hey,

I'm dealing with a problem I cannot solve because I have no idea why it doesn't work.

I'm trying to store some XML into an MSSQL database, using TEXT as fieldtype. I pass the XML as one large string. I don't get any errors but the xml field in my database is left empty. I tryed to use 'set textsize 163840' because my xml-string contains 107.000 characters but that doesn't seem to help.

I also tryed to split my xml-string into parts of 4000 characters, insert the first part and do some updates for the other parts. Also this ain't working.

Does anybody has an idea why an insert with lots of data doesn't work on a text field? I thought columns of type text could contain 2 million bytes?

Greetings,
AsinuS

  • 2 Contributors
  • 1 Reply
  • 76 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by darkagn
Member Avatar for darkagn

Hi AsinuS and welcome to DaniWeb :)

Can you post the query you are using to insert the xml? Also table information might help us to solve your problem too.

We'll start there (at the most basic possible problem) and work our way out...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.