I need to write an XSD, based on which my clients will generate an XML file(version 1.0) which I process an store in database.
I have come across following potential problems.
1. I need to ensure that for some elements, value cannot exceed beyond certain characters, due to database column width limitations.
2. For decimal type, especially % elements, I need value between 0.0000(0%) and 1.0000(100%) without % sign.
How can I enforce this in XSD file.
Also, is there a Windows tools(freeware) which helps me in writing XSD and also validating XML? I am using Visual C++ currently.