XMLDefaultCMapping IBM data server driver configuration keyword

Controls the default C type representation that is used when SQL_C_DEFAULT is specified for XML columns and parameter markers.

Equivalent CLI keyword
MapXMLCDefault
Equivalent IBM® data server provider for .NET connection string keyword
N/A
IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="XMLDefaultCMapping" value="0 | 1 | 2 | 3"/>
Default setting:
0: The default C type representation for XML data is SQL_C_BINARY.
Usage notes:
The XMLDefaultCMapping keyword controls the C type that is used when the SQL_C_DEFAULT type is specified for XML columns and parameter markers. The XMLDefaultCMapping keyword is primarily used with Microsoft applications, such as the Microsoft Access application, which might assume the SQL_C_WCHAR type as the default C type for XML values. The XMLDefaultCMapping keyword can be set to the following values:
  • 0: Sets the SQL_C_BINARY type as the default for XML data.
  • 1: Sets the SQL_C_CHAR type as the default for XML data. Use of the SQL_C_CHAR type for XML data can result in data loss as a result of the code page conversion process.
  • 2: Sets the SQL_C_WCHAR type as the default for XML data.
The XMLDefaultCMapping keyword affects the behavior of CLI functions where the SQL_C_DEFAULT type can be specified, such as in the SQLBindParameter(), SQLBindCol(), and SQLGetData() functions.