O'Reilly logo

Real World XML Web Services: For VB and VB .NET Developers by Yasser Shohoud

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required