enable unicode normalization

enable unicode normalization enables or disables Unilib character normalization.

Summary Information

Default value

1 (on)

Range of values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Unicode

The normalization process modifies the data so there is only a single representation in the database for a given sequence of abstract characters. Often, characters followed by combined diacritics are replaced by precombined forms.

Set enable unicode normalization to 1 to use the built-in process that enforces normalization on all incoming Unicode data. If this parameter is disabled (set to 0), the normalization step is bypassed and the client code is responsible for normalization rather than the server. If normalization is disabled, performance is improved—but only if all clients present Unicode data to the server using the same representation.

Note: Once disabled, you cannot turn normalization on again. This limitation prevents non-normalized data from entering the database.