|
|
Posted by Erland Sommarskog on 06/01/06 21:10
rhaazy (rhaazy@gmail.com) writes:
> I can not pass it as a varchar because the max is 8000 i believe, and
> my xml file is too large for this.
OK, use the text data type then. The important issue is that you should
not pass it as Unicode, that is ntext/nvarchar.
> My solution should be as simple as I have my xml stored into a string
> prior to it being sent to my stored procedure, I should just be able to
> do something like find the int a = string.indexof( <?xml> >
> version="1.0" encoding="utf-8" ?>) then find the length of it then
> delete it from the string. but i dont know what to do after finding the
> index.
As for that question, a C# is a better place.
But as I tried to demonstrate with my repro, there should not be any
need for this.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|