For each of the connection types used for the GTServer client database, here are the recommended field types for the tables specified in the launch actions and the integration actions:

[table “41” not found /]

In the case of SQL Server, the recommended field types depend on the DBMS version AND the type of connection chosen in GTServer.

Boolean or bit fields should generally be avoided as the data storage or driver behaviour is often unsatisfactory.

Non-variable length text fields (char or nchar for most databases) are strongly discouraged (spaces may be added when GTServer extracts the data)