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
- 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 behaviour of CLI functions where SQL_C_DEFAULT
can be specified as a C type, such as
SQLBindParameter(),
SQLBindCol(),
and
SQLGetData().