Special chars in textarea fields --> MySQL
Posted on 2011-09-14
I have a text area field that is inserted into a MySQL db field.
For characters like (Microsoft) quotes, and diacritical vowels, the result that gets inserted (and thus displayed when the record is retrieved on the web site), is translated into other characters.
For instance, apostrophe as in member's
gets captured as â€™
(not sure that will display here: three characters a epsilon trademark )
what is the correct strategy along the way to capture correctly or convert appropriately the common special characters?
Do i need to fabricate a translation table that is applied prior to db INSERTion?