Data Values Embedded as Strings

When the access service receives a SQL command with embedded data values, the SQL transformation mode determines whether any transformation is applied to these values.

Transformation rules:

If the access service is in passthrough mode, it does not perform transformation.
If the access service is in sybase mode, it:
- 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. When passing datatype constants, the client must verify that the constants are in the proper format required by the target DBMS.