- lasercorpAsked on September 02, 2013 at 03:52 PM
When I view the posted data (to insert into mysql) with answers that have an apostrophe or "#" or french accents, I get the following.
[veuillezselectionner] => Lâ€™imprimante a un # dâ€™imprimante de LaserCorp
thanks for the help.
- KadeJMAnswered on September 02, 2013 at 04:21 PM
Hi Eric, That is a very interesting problem. I've taken a look at your form and everything seems configured correctly from what I can tell so far. I'm wondering if there's a problem that might possibly be misfiring this data in the actual script your using to send this but then it seems more like a Special Character issue.
Would you mind if we take a look at the current script you have set up for this? And also do you mind if we test this some more from our end?
- lasercorpAnswered on September 02, 2013 at 09:40 PM
I'm using the code that was posted in teh forum to print the data.
It has always worked well.
yes, please do what you need to to find the solution.
- JotForm SupportEltonCrisAnswered on September 03, 2013 at 12:14 AM
You may encode the values instead to avoid that problem. Example:
$answer = urlencode($_POST['veuillezselectionner']);
Then decode your data everytime you retrieved it from your database.
L’imprimante nécessite une réparation
If you have further questions, let us know here. Thanks!
- lasercorpAnswered on September 03, 2013 at 10:57 PM
The problem happens with apostophes which are part of the ASCII character-set. It is a big problem to encode and decode as the data ia being used in ms access database in numerous places.
There must be an easier way especially since the character is part of the ASCII set.
- JotForm SupportEltonCrisAnswered on September 03, 2013 at 11:43 PM
Yes, I found a simplier way. You just need to define utf-8 as charset of the page. You can use the following meta char set as highlighted in orange below.
$answer = $_POST['veuillezselectionner'];
$answer1 = $_POST['veuillezentrer'];
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8" />
echo $answer. "<br />";
echo $answer1. "<br />";
</html>You can test the first two radio button option on this form: http://jotformpro.com/form/32448869801969Hope this helps. Thanks!