Problem with  symbol and pound sign...

[sparkdigital]

Hi,

I seem to have a problem when copying text into wb from my clipboard - a lot of 'Â' symbols appear. Some of these can be explained by double spaces but others seem to be there without any reason.

A similar problem appears when typing in the £ sign in the cms. This is replaced by an Â. When I change this into '£' in the code this solves it until I open the page again to make some more changes. Wb seesm to overwrite it again as the code just states '£'.

Is there anything I can change in the setting to avoid this?

Hope this makes sense & thanks for your help,

Konrad

[ruebenwurzel]

Hello,

1.  Wich WYSIWYG Editor did you use? If you use the default HTMLArea, maybe FCKEditor or Xinha (both you can find in completed modules) could solve your Problem.

2. Did you try to insert text from f.e. Word or did you try to insert plain text without any formating things? If you insert from word, maybe its better first to insert in a text-editor to get rid of all formating things and then copy this cleaned text in the WYSIWYG Editor.

3. Wich charset have you defined. Look in admin interface at settings, advanced settings. Normally it should be UTF8. But when you have poblems with this try your language specific charset.

Hope this helps

Matthias

[sparkdigital]

Thanks Mattias for your reply, I'll have a look into this and post my findings for future use.

Konrad

[robmock]

I just posted a similar thing [problem] here: http://forum.websitebaker.org/index.php/topic,2138.msg17599.html#msg17599

I was looking through pages made by my users so I don't know if they used a clipboard to copy things, but I am pretty sure they did not copy and paste.

Looks to me like a mysql thing.  In WB settings, Language: english  Charset: utf-8

[sparkdigital]

I think what might have caused the problem was the fact thet I designed the template in dreamweaver (charset=iso-8859-1) where as the default setting in WB is UTF. When I changed this into Latin1 Western European all issues resolved.

Thanks for pointing me in the right direction!

Konrad

[altmann]

I have the same problem. I've got the  symbol as well as an issue with apostrophies like didn’t in place of didn't etc.

Does anyone know how to solve this issue? I'm using HTMLarea, WB ver 2.6.2 and UTF-8 charset. Most of this comes from when i paste the dreamweaver code into the wsywig (initial content for customers who can then edit it).

Is there any way to get rid of the issue with double spaces and apostrophies?

[dbfcs]

I have the same problem. I've got the  symbol as well as an issue with apostrophies like didn’t in place of didn't etc.

Does anyone know how to solve this issue? I'm using HTMLarea, WB ver 2.6.2 and UTF-8 charset. Most of this comes from when i paste the dreamweaver code into the wsywig (initial content for customers who can then edit it).

Is there any way to get rid of the issue with double spaces and apostrophies?

Try changing the encoding to Western European and see if that makes a difference.

[robmock]

It worked for me...    I just copied the Western European "meta" tag out of some other template and that did the trick.

[learning]

Hi There, I am getting this problem on a site that was running and displaying fine, until I changed it to a new server.

Now the   symbol is throughout the pages,  and there are also issues with apostrophies like didn’t in place of didn't etc.

I have made sure the settings are on UTF-8, but it doesn't seem to fix the problem.

Will making these changes fix the already effected text, or will I need to re-do it all?

Cheers
Kel

I am using 2.6.4 WB

[ruebenwurzel]

Hello,

until I changed it to a new server

so you made a database dump and imported it on a new database. I think it yould be a problem with the dumpfile or the mysql versions (Are the new and the old the same version?).

Matthias

[learning]

Hello,

until I changed it to a new server

so you made a database dump and imported it on a new database. I think it yould be a problem with the dumpfile or the mysql versions (Are the new and the old the same version?).

Matthias

I was just coming back to update this post. No, the two servers were/are on different versions. Now my problem is, I can't seem to get back onto the old server to make a new dump file! 

Will have to check with the old server and see what I can do... the nameservers have been changed to reflect the new host, and ever since then I have not been able to log back in to the database myphpadmin.

Thanks for your reply... if there is any other way to fix this without doing a new dump file that would be great.

Cheers

[ruebenwurzel]

Hello,

the dumpfile is only one possible reason. If the old mysql version was mysql 3.x the special chars should be written in the database in utf-8 (german "ä" = "ae"). If the new mysql version is mysql 5.x you have in the database additional charset options. Not worked as much with this, but i think when here are wrong charsets ar defined it could make problems. So look with an editor to the dumpfile how your specialchars are written in the dumpfile. If they are ok in the dumpfile look at the charset of your new database. If you specila chars are wrong in the database mybe a search and replace in the dumpfile dp the trick.

Matthias

[learning]

Yep the old server was on 5.0 and the current is on 4 i think they said.

Right, I have looked at the dump file, and the characters are right through it. So that is the problem. My host suggested making a new dump file and specifying that it is for a older version. I will attmept to do that once I work out how to get back into the old server 

Thanks heaps for your help. 

[learning]

If anyone has any clues here that would be great... cause I am lost for sure!!

I have tried doing another dump file, this time specifying that it was for MySQL4 as my new server has... but when I look at the file the  characters are still all through the content. They even seem to be multiplying now 

I have tried going into the editor and removing them, then saving the page.. but even this is presenting a problem, as to hit 'save' takes me back to the start page of the admin area. Then when I look at the page there are even more odd characters.

Not sure what else to try 

[kweitzel]

You need to get the charset settings right ...

cheers

Klaus

[learning]

You need to get the charset settings right ...

cheers

Klaus

Thanks for your help.

I have checked my template code, it is has

Code:

<meta name="Content-Type" content="text/html; charset=utf-8" />

in it.

And in the settings section of my admin it is set to Unicode utf-8.

Is there anywhere else I should be looking?

[kweitzel]

try putting it to your local one (in Germany it would be iso-8859-1) to display the needed characters correctly.

cheers

Klaus

[learning]

try putting it to your local one (in Germany it would be iso-8859-1) to display the needed characters correctly.

cheers

Klaus

Ok..I will look into that. I am in Australia.

The problem is not getting them to display properly.. it is getting them not to display...lol. They are replacing my 'spaces' randomly.

Cheers

[kweitzel]

spaces randomly? What editor are you using? The default HTML-Area? Try switching to FCK ...

cheers

Klaus

[learning]

Thanks for your help.

Yep I am using HTML Area.. not that it is working properly since the move 

I just tried installing FCK, and when I go to edit a page it just comes up with a blank edit area, no text, no tool bar. No idea why, as it works perfectly on other sites I use.

So I am back to HTML Area, if I make any changes on the page, when I hit enter it just takes me back to the start page, and doesn't make the changes.

I am starting to think I am going to have to start all over again with this site.... I just can't seem to get it working properly, even though it was working fine on the other server.

I have changed the charset settings, and all the random symbols are still showing up.

Just at a bit of a loss as what to try next 

It could very well be issues from the old server, as I had a really hard time getting wb to work on their servers in the first place.. hence why I have now changed from them.

[kweitzel]

OK ... then just try first with a clean install of WB (for testing purposes). Remember to switch the filesystem settings from Linux/Unix to Windows. Then you can try following way:

Steps
1) Install the required modules, languages and templates
2) Copy the page folder to your new server
3) make a dump of the following DB Tables (substitute "prefix" with the table prefix you use):

• prefix_pages
• prefix_sections (if you use different sections per page)
• prefix_mod_wysiwyg (you might need to rework the links ...)
• prefix_mod_news_* (if you use the newsmodule)
• prefix_mod_form_* (if you use a formpage)

(no guarantee, that I didn't forget anything) ...
4) upload the dumpfile to you new WB DB (make shure, that the tableprefix is the same!)

Hope it works ...

cheers

Klaus

[learning]

Thanks Klaus... sorry it has taken me so long to reply to this. 

I appreciate all your help, you are fantastic. I ended up having to resort to a new install, but it wasn't so bad, as it was a new and small site, thank goodness. 

Thanks again. 

[syamfamily]

You need to get the charset settings right ...

cheers

Klaus

Thanks for your help.

I have checked my template code, it is has

Code:

<meta name="Content-Type" content="text/html; charset=utf-8" />

in it.

And in the settings section of my admin it is set to Unicode utf-8.

Is there anywhere else I should be looking?

Thanks...it works..