Microsoft SQL Server

Microsoft SQL Server#

Microsoft Microsoft SQL Server ADO.Net driver is bundled with Querona and is ready to use.

See also#

Connection collation#

The available collation options depend on the selected SQL Server dialect version in the connection settings:

  • For dialect versions below SQL Server 2019: SQL_Latin1_General_CP1_CI_AS.

  • For SQL Server 2019 and newer: Latin1_General_100_CI_AS_KS_WS_SC_UTF8 (default) and Latin1_General_100_CI_AS_KS_WS_SC, SQL_Latin1_General_CP1_CI_AS.

See also Create a connection for full SQL Server connection parameter details.