MapXMLCDefault CLI/ODBC and IBM data server driver configuration keyword

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

db2cli.ini keyword syntax:
MapXMLCDefault = 0 | 1 | 2 | 3
IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
<parameter name="MapXMLCDefault" value="0 | 1 | 2 | 3"/>
Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
Default setting:
The default C type representation for XML data is SQL_C_BINARY.
Usage notes:
 
MapXMLCDefault controls the C type that is used when SQL_C_DEFAULT is specified for XML columns and parameter markers. This keyword should be used primarily with Microsoft applications, such as Microsoft Access, which might assume SQL_C_WCHAR as the default C type for XML values. Set MapXMLCDefault as follows:
  • 0 - for the default SQL_C_BINARY C type representation
  • 1 - for the SQL_C_CHAR C type representation; this can result in data loss as the XML data is converted to the local application code page
  • 2 - for the SQL_C_WCHAR C type representation
This keyword affects the behavior of CLI functions where SQL_C_DEFAULT can be specified as a C type, such as SQLBindParameter(), SQLBindCol(), and SQLGetData().