Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › odd characters in HTMLEditor

odd characters in HTMLEditor

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

3/21/2013 8:39 am | #1 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

3/21/2013 10:41 am | #2 Jason ByrnesWebAssist

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

3/21/2013 11:19 am | #3 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

3/21/2013 12:26 pm | #4 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.

3/21/2013 12:33 pm | #5 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

3/21/2013 3:42 pm | #6 PatriceWebAssist

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

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.