Appendix A. Data Type Mappings
To read this table, locate the XML Schema type that you want to look up, then read across to find the corresponding SQL Server and .NET data types. Note that some schema types have no direct mapping in SQL Server. To handle these, you need to convert them into a SQL Server supported type. For example, anyURI has no direct mapping in SQL Server; instead you store it as a string (varchar).
There are also some types that have no SQL Server mappings and could potentially lose information if you convert them. For example, unsignedLong is an unsigned 64-bit integer. SQL Server has no support for such types (bigint is a signed 64-bit integer) so you can either convert it to a signed 64-bit integer, which changes the range ...
Get Real World XML Web Services: For VB and VB .NET Developers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
