close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

odd characters in HTMLEditor

Thread began 3/21/2013 11:39 am by Christopher West | Last modified 3/21/2013 6:42 pm by Patrice | 411 views | 5 replies |

Christopher WestCommunity Expert

odd characters in HTMLEditor

Just a quicky...Using HTMLEditor

and I have noticed that on some pages I had odd characters being displayed...on inspecting the actual database I noticed that these characters were made up of code such as..  

Im assumning its only happening when copy/pasting in text.. even removing formatting doesnt do anything and even deleting the odd character and replacing it sometimes doesnt help.

I just wondered why these characters would appear?

in my pages the doctype etc is:
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta http-equiv="Content-Language" content="en-gb">

and in my database the tables are created as: InnoDB Latin1_Swedish_ci (the default)
should it be utf8_general_ci ??

Or am I missing something else?


Chris

Sign in to reply to this post

Jason ByrnesWebAssist

Use the Dynamic Connections for creating the database connection, in Dynamic Connections, set the character set for the connection to UTF-8

Sign in to reply to this post

Christopher WestCommunity Expert

Hi Jason couple of questions.
1. I have always used the standard database connection rather then the dynamic one...so what difference would that make to UTF8..Why wouldnt the previous connection be good enough?

2. Should I be setting all my database tables to use utf8_general_ci then? Is this optimised for the use of HTMLEditor?

I have done the connection you stated, i deleted the previous one and deleted the localhost files and recreated them...now im getting this †is quite a few areas of my content...would i now need to go through the whole content of the website to correct manually in the database?

and will this change reflect any future edits of the content?

Chris

Sign in to reply to this post

Jason ByrnesWebAssist

1) The standard DW Connection doesn't allow you to set the character set used for the connection. This can cause UTF - 8 characters to become munged during transmission from the form to the database. the default connection character set is the iso-8859-1 character set.

doesn't matter what the database character set is if the connection is transmitting to and from the database using the iso-8859-1 character set.

2) It's not so much about optimized for HTML Editor, as it for the language characters you will be using.


changing the character set cant correct problems that already exist, but it should prevent them from being inserted in the future.

Sign in to reply to this post

Christopher WestCommunity Expert

Thanks Jason, I have always used the standard database connection setup. so for future will use the webassist version and use utf8. I just want to try and keep to one standard since all the web projects I do are all UK based so I dont need to mess around with different character sets. just the one generic one for English speaking content.

Chris

Sign in to reply to this post

Patrice

Thanks for this post and solution. I ran into the same thing last week. I assumed it was the copy paste issue too.
This was my post link: showthread.php?t=30377

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...