# FormSnap Encoding

**URL:** <https://forums.realmacsoftware.com/t/formsnap-encoding/3173>\
**Category:** RapidWeaver Classic\
**Created:** [October 9, 2015, 5:05pm UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173 "2015-10-09T17:05:22Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![dudeneyge](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/dudeneyge/32/563_2.png) [@dudeneyge](https://forums.realmacsoftware.com/u/dudeneyge)\
**Post date:** [October 9, 2015, 5:05pm UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/1 "2015-10-09T17:05:23Z")

</div>

Hi All,

I have a FormSnap form successfully sending out email, and posting to a database. The only slight issue is that a word like _ **I’m** _ ends up as _ **I'm** _ in the database. It’s not a biggy, but it’s annoying. For FormSnap I have **Email encoding** set to _quoted-printable_ and **Email charset** set to _utf-8 (8-but unicode)_. Columns in the database table are all set to _utf8\_unicode\_ci._

I did fill in a support request on the developer’s site, but have heard nothing. Anybody any idea of where I’m going wrong?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![mastermix](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@mastermix](https://forums.realmacsoftware.com/u/mastermix)\
**Post date:** [October 10, 2015, 12:12am UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/2 "2015-10-10T00:12:33Z")

</div>

This post was flagged by the community and is temporarily hidden.

---

<div class="post-metadata">

**Author:** ![dudeneyge](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/dudeneyge/32/563_2.png) [@dudeneyge](https://forums.realmacsoftware.com/u/dudeneyge)\
**Post date:** [October 10, 2015, 7:28pm UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/3 "2015-10-10T19:28:03Z")

</div>

Kris,

Thanks for your suggestion. I’m on MySQL 5.6.23. I tried changing the collation to utf8mb4\_bin but I’m still getting the same thing. I checked PHP config and magic quotes are turned off, so I’m at a loss. ANy other ideas?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![mastermix](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@mastermix](https://forums.realmacsoftware.com/u/mastermix)\
**Post date:** [October 10, 2015, 9:22pm UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/4 "2015-10-10T21:22:12Z")

</div>

This post was flagged by the community and is temporarily hidden.

---

<div class="post-metadata">

**Author:** ![dudeneyge](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/dudeneyge/32/563_2.png) [@dudeneyge](https://forums.realmacsoftware.com/u/dudeneyge)\
**Post date:** [October 10, 2015, 10:01pm UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/5 "2015-10-10T22:01:11Z")

</div>

Kris,

I appreciate your suggestions - thanks so much. I’ve just inserted a new record via PHPMyAdmin and the apostrophes insert correctly with no escaping. I’m assuming, therefore, that it’s what’s being sent from the form which is incorrectly formatted. The form emails and adds to database, email arrives in this format:

I’m testing apostrophes. They’re great. Please ignore…

So, presumably it’s at the form end where this is happening.

---

<div class="post-metadata">

**Author:** ![mastermix](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@mastermix](https://forums.realmacsoftware.com/u/mastermix)\
**Post date:** [October 11, 2015, 9:42am UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/6 "2015-10-11T09:42:34Z")

</div>

This post was flagged by the community and is temporarily hidden.

---

<div class="post-metadata">

**Author:** ![mastermix](https://avatars.discourse-cdn.com/v4/letter/m/edb3f5/32.png) [@mastermix](https://forums.realmacsoftware.com/u/mastermix)\
**Post date:** [October 11, 2015, 10:13am UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/7 "2015-10-11T10:13:07Z")

</div>

This post was flagged by the community and is temporarily hidden.

---

<div class="post-metadata">

**Author:** ![c.steuernagel](https://avatars.discourse-cdn.com/v4/letter/c/59ef9b/32.png) [@c.steuernagel](https://forums.realmacsoftware.com/u/c.steuernagel)\
**Post date:** [May 20, 2025, 6:04pm UTC](https://forums.realmacsoftware.com/t/formsnap-encoding/3173/8 "2025-05-20T18:04:37Z")

</div>

In rapidweraver 8 I am trying to connect my formsnap3-form to the mysql database. All connection data are correct but I always get the 1064-Error for Line 1. I try it with only 2 fields giving them the TEXT-attribute in formsnap and in the mysql-Database. Do you haven idea what ist wrong ?  
Thanks for your answer !