CONVERT_VARCHAR_TO_1242 option

Function

Converts pre-version 12.4.2 VARCHAR data to compressed format.

Allowed values

ON, OFF

Scope

Can only be set for the PUBLIC group. Takes effect when you run sp_iqcheckdb in any mode.

Default

OFF

Description

Helps further compress data and improve performance, especially for databases with many variable character strings.

You set this option and then run sp_iqcheckdb only once, and only for VARCHAR columns that were created before Version 12.4.2.