https://legacy.forums.gravityhelp.com/topic/fix-for-localizations-that-use-and-differently Gravity Support Forums Topic: Fix for localizations that use . and , differently en-US Mon, 20 Apr 2026 15:27:13 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/fix-for-localizations-that-use-and-differently#post-58570 Thu, 10 May 2012 12:33:53 +0000 Alex Cancado 58570@https://legacy.forums.gravityhelp.com/ <p>Ok. I have a dev version with the changes. If you want to give it a try, email me to <a href="mailto:alex@rocketgenius.com">alex@rocketgenius.com</a> and I will send it your way. </p> https://legacy.forums.gravityhelp.com/topic/fix-for-localizations-that-use-and-differently#post-58560 Thu, 10 May 2012 11:54:12 +0000 sboisvert@bryxal.ca 58560@https://legacy.forums.gravityhelp.com/ <p>Thanks!<br /> I'm not 100% sure, that it is the only change to get rid of any and all bugs regarding running wp in a localized environement. But this change Gets rid of all the apparent bugs regarding fields longer than the varchar in non-en_us localizations. I will let you know if we find others.</p> <p>Thanks again,</p> <p>-Steph </p> https://legacy.forums.gravityhelp.com/topic/fix-for-localizations-that-use-and-differently#post-58553 Thu, 10 May 2012 11:42:23 +0000 Alex Cancado 58553@https://legacy.forums.gravityhelp.com/ <p>I don't have a problem making this change, but I think changing the number localization on the server will create other problems as well. Are you sure this is the only change needed? </p> https://legacy.forums.gravityhelp.com/topic/fix-for-localizations-that-use-and-differently#post-58458 Wed, 09 May 2012 23:21:21 +0000 sboisvert@bryxal.ca 58458@https://legacy.forums.gravityhelp.com/ <p>When using French Canadian Localization on the server. The floats will be converted from 1.1 to 1,1 in the SQL (the %f) and will mess up the query to get the detail_long.<br /> Changing line 2305 of forms_model.php from:</p> <p>WHERE lead_id=%d AND field_number BETWEEN %f AND %f", $lead["id"], $field_number - 0.001, $field_number + 0.001);</p> <p>to this one where the double gets interpreted in PHP and then passed as a string in SQL, you get the same level of security just at a different layer.</p> <p>WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $lead["id"], doubleval($field_number - 0.001),doubleval($field_number + 0.001));</p> <p>Thank you </p>