https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us Gravity Support Forums Topic: Field Values cut off at 200 chars in locales different than EN_US en-US Mon, 20 Apr 2026 15:29:49 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us#post-54023 Mon, 02 Apr 2012 16:38:16 +0000 sboisvert@bryxal.ca 54023@https://legacy.forums.gravityhelp.com/ <p>Note for the original bug, I've fixed it this way to keep the double val and not have it change the values to localized floats for the SQL statement</p> <p>in get_field_value_long() change to:</p> <p> $sql = $wpdb-&gt;prepare(" SELECT l.value FROM $detail_table_name d<br /> INNER JOIN $long_table_name l ON l.lead_detail_id = d.id<br /> WHERE lead_id=%d AND field_number BETWEEN %s AND %s", $lead_id, doubleval($field_number - 0.001),doubleval($field_number + 0.001)); </p> https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us#post-53779 Thu, 29 Mar 2012 13:04:29 +0000 sboisvert@bryxal.ca 53779@https://legacy.forums.gravityhelp.com/ <p>Now this (standard build, without my changes, latest version) has the repercussions that having wordpress load up with the French locale (fr_ca or fr_fr in French where doubles are stored as 14,1 internally makes gravity forms not recognize any address field or other field that has the 14.1 field numbering.<br /> Those fields are not processed by:<br /> if($lead != null &amp;&amp; $value == rgget($input_id, $lead)) line 1883 of forms_model.php in the function save_input() </p> https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us#post-44274 Fri, 16 Dec 2011 18:18:19 +0000 sboisvert@bryxal.ca 44274@https://legacy.forums.gravityhelp.com/ <p>Hi Carl, these are two separate forms.</p> <p>Just to note this problem is still in the most recent version of Gravity forms. And it still cuts off after 200 characters. (From my understanding this is that the long field doesn't get recognized and therefore only the shorter 200 char version field gets used)</p> <p>It is now in line 2089:<br /> get_field_value_long()<br /> from:<br /> $sql = $wpdb-&gt;prepare(" SELECT l.value FROM $detail_table_name d<br /> INNER JOIN $long_table_name l ON l.lead_detail_id = d.id<br /> WHERE lead_id=%d AND field_number BETWEEN %f AND %f", $lead_id, $field_number - 0.001, $field_number + 0.001);<br /> to:<br /> $sql = $wpdb-&gt;prepare(" SELECT l.value FROM $detail_table_name d<br /> INNER JOIN $long_table_name l ON l.lead_detail_id = d.id<br /> WHERE lead_id=%d AND field_number = %d ", $lead_id, $field_number);</p> <p>Thanks.</p> <p>(Again, I saw that this is not the right way to fix it, but just re-showing what I did to fix it, I understand it won't work for multi-fields and am keen on helping you fix it as we are using Gravity forms more and more) </p> https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us#post-10449 Mon, 27 Sep 2010 17:16:57 +0000 Carl Hancock 10449@https://legacy.forums.gravityhelp.com/ <p>How is this implemented? Are you using the same form and using WPML to translate them some how or are those 2 separate forms? </p> https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us#post-10448 Mon, 27 Sep 2010 16:59:04 +0000 sboisvert@bryxal.ca 10448@https://legacy.forums.gravityhelp.com/ <p>Thank you Alex,<br /> Every entry gets cut off at 200 char.<br /> Its a standard Paragraph text.<br /> We are using the WPML plugin to manage the multiple locales on our blog, that will make it easier for you to test with the French locale. </p> <p>you can view both the french and english versions of the forms here:<br /> <a href="http://www.liberal.ca/fr/contactez-nous/" rel="nofollow">http://www.liberal.ca/fr/contactez-nous/</a><br /> <a href="http://www.liberal.ca/contact/" rel="nofollow">http://www.liberal.ca/contact/</a></p> <p>Thank you, </p> https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us#post-10446 Mon, 27 Sep 2010 16:41:31 +0000 Alex Cancado 10446@https://legacy.forums.gravityhelp.com/ <p>Does it fail for every entry or just for ones with commas in it?<br /> The field_number needs to be a float because multi-input fields such as name and address store each input value (first name, last name, etc..) as a float. So your solution might work for basic fields but it won't work on all scenarios. If the BETWEEN syntax is creating issues for the french locale, I can look into fixing the problem. Can you give me a detailed description on how to replicate the issue? </p> https://legacy.forums.gravityhelp.com/topic/field-values-cut-off-at-200-chars-in-locales-different-than-en_us#post-10443 Mon, 27 Sep 2010 16:22:29 +0000 sboisvert@bryxal.ca 10443@https://legacy.forums.gravityhelp.com/ <p>I had a rought time figuring it out but finnaly I found the bug,<br /> on line 1390 of forms_model.php<br /> "WHERE lead_id=%d AND field_number = %d ", $lead_id, $field_number - 0.001, $field_number + 0.001);"<br /> That fails when the wordpress Locale is something like French, the commas get interpreted differently somewhere in the prepare statement and the query fails and you get stuck with the short version of the string.</p> <p>changing the line to this:<br /> "WHERE lead_id=%d AND field_number = %d ", $lead_id, $field_number);"<br /> will fix the issue.<br /> I saw other places in the code where Between is used with the same logic of using floats instead of Int in the SQL query. I'm not entirely sure why it was done, I'm sure there was a logical reason at some point in time (or debugging and never got put back).<br /> Either way, I hope it can be of use to others.</p> <p>-S </p>