KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Beginning with 4D v15 R4 Regional Settings decimal separator is "." only
PRODUCT: 4D | VERSION: 15 R4 | PLATFORM: Mac & Win
Published On: June 2, 2016

Beginning with 4D v15 R4 Regional Settings are ignored with regards to the decimal separator placed in a string.

In earlier versions of 4D, the 4D Transformation Tags 4DTEXT, 4DVAR, 4DHTML, 4DHTMLVAR, and 4DEVAL depended on the Operating System's Regional Settings to determine what the decimal separator would be when converting a number to a string. Beginning with 4D v15 R4 this 4D Tags strictly uses the dot, ".", as the decimal separator

In the image below, only the countries shown in blue used the dot as its decimal separator. All other countries use a comma or some other character as the decimal separator.



There are a number of reasons for this change but significant among the reasons is that a number of XML grammars, such as SVG, require the decimal separtor to be the dot.

Beginning with 4D v15 R4 if the regional setting has to be used it has to be done in the form of...

<!--#4DTAG String:C10($Num;"&xml")-->