Last post Sep 30, 2008 07:08 AM by RedSunBeer
Dec 27, 2007 03:06 AM|dilip12|LINK
I have a talbe with a column type varchar(8000). i am facing problems sometimes as it corsses the limit also have the problems with special characters. so i went through few articles and been advised to use xml datatype. but when i am changing comumn name
from varchar (8000) to xml as:
alter table tblStudentForm alter column FormDetails xml not null
i am getting following error:
Msg 9400, Level 16, State 1, Line 1
XML parsing: line 46, character 402, unexpected end of input
The statement has been terminated.
Please any one can advice how to alter on this.
Dec 27, 2007 03:59 AM|jimmy q|LINK
XML data type means the data in it must be well formed XML with appropriate tags.
Have you considered changing the column to a TEXT data type?
Dec 27, 2007 04:25 AM|noahb|LINK
it seems you have some non well formed xml in there.... unless you fix all the instances of this, you won't be able to alter the column. You might want to convert it to varchar(max) which can handle 2gb per instance and still compatible with the string
Sep 30, 2008 07:08 AM|RedSunBeer|LINK