Trademark symbols disappearing from content

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
4/4/2011 11:47:11 PM
rdpinkerton
Gravatar
Total Posts 46
View Posts

Trademark symbols disappearing from content

I have a client whose hosting was at GoDaddy (shared) and it performed appallingly. Today I migrated the client's site to Hostgator and a dedicated server. The only difference between the two sites is that the GoDaddy version is running in Medium Trust and the Hostgator in Full Trust. The version of MySQL at GoDaddy is 5.0 and at Hostgator is 5.1.

Everything works perfectly except when I edit content on the Hostgator site that contains a trademark symbol, a superscripted TM is replaced with a capital T on retrieval from the database. The character set of both databases is UTF-8. Both configurations use TinyMCE for their editor.

I have now torn all my hair out trying to resolve this and have spent hours on the issue. Could someone point me in a direction? 

Thanks for any assistance.


Bob

4/5/2011 12:17:13 AM
rdpinkerton
Gravatar
Total Posts 46
View Posts

Update (UNRESOLVED): Trademark symbols disappearing from content

I used SQL Maestro for MySQL to edit the content of the longtext field (body) that is used in the table mp_htmltext and added in ™ then ™ and then ™ I verified these values were updated to the field and then refreshed the page in a browser. The TM symbols were retrieved correctly. Then I edited the article using TinyMCE in mojoPortal and when I updated the TM fields were stripped and reduced to a capital "T". This was true for all 3 symbols.

Weird.

4/5/2011 9:35:07 AM
Jamie E
Gravatar
Total Posts 1203
View Posts
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Trademark symbols disappearing from content

Have you tried CKEditor yet?

4/5/2011 9:43:58 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Trademark symbols disappearing from content

Does your connection string specify utf-8 like this?:

<add key="MySqlConnectionString" value="Server=localhost;Database=mojo_prod;Uid=myuser;Pwd=mypassword;Charset=utf8;" />

If it is a database issue it should be the same in any editor I'm trying it here with CKeditor ™

Hope it helps,

Joe

4/5/2011 11:30:02 AM
rdpinkerton
Gravatar
Total Posts 46
View Posts

Re: Trademark symbols disappearing from content

Joe: my connection string doesn't specify a character set. I'll give that a try. Jamie: first attempt to diagnose was to cycle through the editors. No change to the behavior. I'll try the explicit charset in the connection string and then try updating to the latest version.
4/5/2011 2:59:13 PM
rdpinkerton
Gravatar
Total Posts 46
View Posts

Update (RESOLVED): Trademark symbols disappearing from content

I updated the connection string to explicitly include the character set and the problem is solved.

Thanks very much.

Bob

You must sign in to post in the forums. This thread is closed to new posts.