When the access service receives a SQL command with embedded data values, the SQL transformation mode in effect determines whether any transformation is applied to these values. These rules apply:
If the access service is in passthrough mode, it does not perform transformation.
If the access service is in sybase mode, it performs this transformation:
Removes the currency symbol from money datatypes
Transforms quoted strings to quoting conventions specific to the target DBMS
Datatype constants are not transformed in any way except as described previously. When passing datatype constants, the client must verify that the constants are in the proper format required by the target DBMS.
For more information about SQL transformation modes, see Chapter 5, “Issuing SQL Statements.”
