CONVERT_VARCHAR_TO_1242 option

Function

Converts pre-version 12.4.2 VARCHAR data to compressed format.

Allowed values

ON, OFF

Default

OFF

Scope

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

Description

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

Set this option and then run sp_iqcheckdb only once, and only for VARCHAR columns that were created before version 12.4.2.