Symbology is lost when a data layer is displayed on a locale that uses commas as the decimal delimiter

Description

When a data layer that is created using the Unique Values renderer is displayed on a locale that uses a comma as the decimal delimiter, the symbology is lost.

Cause

If the layer file is created in a locale that uses decimals (.) and is displayed in a locale that uses commas (,) as the decimal delimiter, the data is not symbolized as expected. This is because the values coming from the database do not match the string values stored in the renderer that is in the layer file. On a machine with an English locale, the values may be 8.45 and 10.55, but they are interpreted as 8,45 and 10,55 on a French locale machine.

Other feature renderers, such as the Class Breaks renderer, display correctly when the decimal delimiter changes to a comma. Also, when rendering raster data using the Unique Values renderer and the Class Breaks renderer, the data displays correctly on the French language OS.

Solution or Workaround