Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › strange characters in db

strange characters in db

Thread began 10/05/2016 12:40 pm by art226587 | Last modified 10/06/2016 10:20 am by Ray Borduin | 510 views | 1 replies |

10/05/2016 12:40 pm | #1 art226587

strange characters in db

Hi, is there a way to preserve special characters so that they get stored correctly in the db instead of turning into these groups of "???" q-marks (see attachment)? I can identify in this example that apostrophes (not foot marks), quote marks (not inch marks), ellipses (...) and em dashes are currently getting garbled.

My client is likely pasting content from mixed sources such as MS Outlook and/or MS Word - I know, I know.

The character set on the form page is set as such: <meta charset="utf-8">.

Any help would be greatly appreciated!

10/05/2016 2:17 pm | #2 art226587

UPDATE: I figured this one out! Apparently, my db table collation was set to ascii_general_ci. I switched all fields to utf8_general_ci and everything looks right now.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.