SQL Formatter writes constant value expressions depend on current culture. Also string operations in some other classes is based on current culture. As current culture is variant based on user Environment (OS) and its options may be changed by end-user, this may lead to generating some critical errors in the formatted SQL sentence's syntax with constant values (specially with cultures with locale-specific decimal separator rather than dot '.' character).
For example when we expect SQLFormatter to write constant value 1.5 it may write it in windows with locale French 1,5 or locale Persian(farsi) 1/5 and therefore cannot be executed with this syntax error.
SQL Formatter writes constant value expressions depend on current culture. Also string operations in some other classes is based on current culture. As current culture is variant based on user Environment (OS) and its options may be changed by end-user, this may lead to generating some critical errors in the formatted SQL sentence's syntax with constant values (specially with cultures with locale-specific decimal separator rather than dot '.' character). For example when we expect
SQLFormatter
to write constant value1.5
it may write it in windows with locale French1,5
or locale Persian(farsi)1/5
and therefore cannot be executed with this syntax error.