G
Goh
Hi,
I found problem to store infopath xml file to SQL 2005 which xml
datatype. The error cause because I cannot create the same schema as what I
did in infopath.
SQL throw an error
The XML Schema syntax 'processContents="lax"' is not supported.
I doing some research I found that lax is for RichText Box to allow all
xhtml tag to be save. How to resolve this issue? Don't use RichTextBox if
goal is to save in SQL server?
The second constrain that I cannot store in SQL 2005 xml datatype is the
different between encoding. InfoPath create xml in UTF-8 but SQL 2005 not
allow UTF-8 but UTF-16.
After I manually create a schema for SQL 2005 which change those lax to
skip and UTF-8 to UTF-16. schema have successfully store in SQL server.
The problem come again where Invalid simple type value throw. This node
actually having Time text like 03:40:10 with type=xsd:time .
Any expert please help me, my goal is to save all xml document create by
infopath store in a centralized place for future processing.
Thank in advance for any comment and sharing.
With regards,
Goh
I found problem to store infopath xml file to SQL 2005 which xml
datatype. The error cause because I cannot create the same schema as what I
did in infopath.
SQL throw an error
The XML Schema syntax 'processContents="lax"' is not supported.
I doing some research I found that lax is for RichText Box to allow all
xhtml tag to be save. How to resolve this issue? Don't use RichTextBox if
goal is to save in SQL server?
The second constrain that I cannot store in SQL 2005 xml datatype is the
different between encoding. InfoPath create xml in UTF-8 but SQL 2005 not
allow UTF-8 but UTF-16.
After I manually create a schema for SQL 2005 which change those lax to
skip and UTF-8 to UTF-16. schema have successfully store in SQL server.
The problem come again where Invalid simple type value throw. This node
actually having Time text like 03:40:10 with type=xsd:time .
Any expert please help me, my goal is to save all xml document create by
infopath store in a centralized place for future processing.
Thank in advance for any comment and sharing.
With regards,
Goh