How EFT Server Handles SQL Data

EFT server truncates data values within each audited event SQL transaction to ensure the data value fits within the corresponding database field.

The special characters (as defined by the SQL interpreter) within each data value of an audit SQL event are escaped to ensure the data value is stored and retrieved properly from the database. The following special characters are escaped by EFT Server during generation of SQL statements prior to submission to the database engine:

• Single quote - %

• Open brace - [

• Percent - %

• Underscore - _