Datatype Conversion Properties

Controls how an access service converts target database datatypes to Open Client™ and Open Server datatypes before sending the data to the client application.

{Datatype Conversion}
BinaryResults=
DateResults=
DateTimeResults=
DecimalResults=
FloatResults=
Int2Results=
Int4results=
RealResults=
TimeResults=
TinyIntResults=
XNLChar=
XNLVarChar=

• BinaryResults
  Specifies the Open Server datatype to which returned binary results are converted.
• DateResults
  Specifies the Open Client and Open Server datatype to which an access service converts to date results.
• DateTimeResults
  Specifies the Open Client and Open Server datatype to which an access service converts to ODBC timestamp results.
• DecimalResults
  Specifies the Open Client and Open Server datatype to which an access service converts to decimal results.
• FloatResults
  Specifies the Open Client and Open Server datatype to which an access service converts to float results.
• Int2Results
  Specifies the Open Client and Open Server datatype to which an access service converts to small integer results.
• Int4Results
  Specifies the Open Client and Open Server datatype to which an access service converts to integer results.
• RealResults
  Specifies the Open Client and Open Server datatype to which an access service converts to real results.
• TimeResults
  Specifies the Open Client and Open Server datatype to which an access service converts to time results.
• TinyIntResults
  Specifies the Open Client and Open Server datatype to which an access service converts to TinyIntResults.
• XNLChar
  Specifies the maximum size of both char and binary results. If the maximum size is exceeded, the datatype is promoted to text and image, respectively.
• XNLVarChar
  Specifies the maximum size of both varchar and varbinary results. If the maximum size is exceeded, the datatype is promoted to text and image, respectively.