The REPORTSTRINGASWSTRING provider string keyword
The provider-string keyword RSASWS or REPORTSTRINGASWSTRING in the provider string Extended Properties enables you to control the data mapping for wide strings.
When this keyword is set to TRUE, OLE DB Provider reports DBTYPE_WSTR as a best fit for all the underlying string length data types (CHAR, VARCHAR, TEXT, and other data types) and not DBTYPE_STR, which is the normal mapping. The default setting for REPORTSTRINGASWSTRING is FALSE.
The syntax for setting this keyword is as follows
(two forms of this keyword are provided; you might use either one):
- Short form:
RSASWS=TRUEorRSASWS=FALSE - Long form:
REPORTSTRINGASWSTRING=TRUEorREPORTSTRINGASWSTRING=FALSE