|
Quotes |
" ... I want to tell you that your thyme product is functional and valuable beyond
words. I cannot imagine why any portal would be without it. It is the cornerstone of our new project ..."
" ... Thanks for such a complete project, its making my job much easier. ..."
" ... I have now deployed 4 different calendars and our users love them ... "
" ... Easy to install and use and a great look/design. ..."
" ... This has to be the easiest to use program I think I've had to deal with at all this year. ..."
|
|
| View previous topic :: View next topic |
| Author |
Message |
copeland
Joined: 05 May 2008
Posts: 20
|
 Posted: Wed Aug 06, 2008 1:45 am Post subject: Ascii characters showing... |
 |
|
Hi Ian,
I'm currently getting ascii characters showing when some users are entering entries to calendars.
These include the single and double, right and left quotation marks, aswell as the dash and sometimes on spaces. (eg. ’)
They are entering using the thyme backend, as it is easier then adding through the joomla frontend.
http://www.webchild.com.au
I have just put together and run this SQL query to fix what has been done, but it isn't very feasible since i cannot continuously run the query.
| Quote: |
UPDATE thyme_Events SET notes = REPLACE(notes, "'", "'");
UPDATE thyme_Events SET notes = REPLACE(notes, """, '"');
UPDATE thyme_Events SET notes = REPLACE(notes, " ", " ");
UPDATE thyme_Events SET notes = REPLACE(notes, "<br />", "\n");
UPDATE thyme_Events SET notes = REPLACE(notes, "<br>", "\n");
UPDATE thyme_Events SET notes = REPLACE(notes, "<", "<");
UPDATE thyme_Events SET notes = REPLACE(notes, ">", ">");
UPDATE thyme_Events SET notes = REPLACE(notes, "&", "&");
UPDATE thyme_Events SET notes = REPLACE(notes, "’", "’");
UPDATE thyme_Events SET notes = REPLACE(notes, "‘", "‘");
UPDATE thyme_Events SET notes = REPLACE(notes, "”", '”');
UPDATE thyme_Events SET notes = REPLACE(notes, "“", '“');
UPDATE thyme_Events SET notes = REPLACE(notes, "–", "–"); |
Thanks Mike |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
Forums 
FAQ
Search
Register
Log in
