TDV Adapter for MySQL

Build 22.0.8462

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


PropertyDescription
AllowUserVariablesWhen set to True, user variables (prefixed by an @) can be used in SQL queries.
CharactersetThe default client character set used by the provider. For example, 'utf8'.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
ReadonlyYou can use this property to enforce read-only access to MySQL from the provider.
ServerTimeZoneSpecify a specific server time zone id of current platform(.Net or Java) by user.
TimeoutThe value in seconds until the connection timeout error is thrown.
ZeroDatesToNullWhether or not to return Date and DateTime values consisting of all zeros as NULL.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462