http://wordpress.org/support/ WordPress › Support Tag: weird character en Tue, 24 Nov 2009 08:21:55 +0000 http://wordpress.org/support/topic/226955#post-1061028 Thu, 30 Apr 2009 15:55:56 +0000 rickandersonaia 1061028@http://wordpress.org/support/ <p>Here's how I fixed the problem.<br /> 1. Make sure the database has everything at utf-8<br /> 2. Make sure WP settings has utf-8<br /> 3. Edit the PHP.ini file on my server to add <strong>default_charset = "utf-8"</strong></p> <p>That fixed it - I relied on this article <a href="http://htmlpurifier.org/docs/enduser-utf8.html#findcharset">UTF-8: The Secret of Character Encoding</a> to help me understand the issue. </p> http://wordpress.org/support/topic/226955#post-994233 Sun, 22 Feb 2009 04:34:18 +0000 Asta 994233@http://wordpress.org/support/ <p>There is a plugin that solves this without monkeying with the config file:</p> <p><a href="http://wordpress.org/extend/plugins/utf-8-database-converter/" rel="nofollow">http://wordpress.org/extend/plugins/utf-8-database-converter/</a> </p> http://wordpress.org/support/topic/226955#post-992155 Fri, 20 Feb 2009 03:43:12 +0000 groovyKimo 992155@http://wordpress.org/support/ <p>Hi all</p> <p>For me this did the trick after updating to 2.7: </p> <pre><code>define(&#39;DB_CHARSET&#39;, &#39;utf8&#39;); define(&#39;DB_COLLATE&#39;, &#39;utf8_unicode_ci&#39;);</code></pre> <p>As I understand it, db_collate should be the same setting as in your database, where you can set the db_collate for the whole database, while every table got a charset-setting too. In my database, everything is utf8_unicode_ci. </p> <p>Hope this helps someone... :) </p> http://wordpress.org/support/topic/226955#post-983732 Thu, 12 Feb 2009 12:38:06 +0000 redpillnews.org 983732@http://wordpress.org/support/ <p>brandonsnhl,</p> <p>I had the exact same problem as you. I was migrating from an older mysql 4.1.x database to 5.x.x. After the import a bunch of weird characters were showing, especially the funny A</p> <p>I went in and edited my wp-config file, added the text you showed us and it fixed my problem too. Hope that helps someone else upgrading from older mysql database.</p> <p>Cheers' </p> http://wordpress.org/support/topic/226955#post-970029 Thu, 29 Jan 2009 16:19:13 +0000 fbruno69 970029@http://wordpress.org/support/ <p>I had the same problem - which happens with every update.</p> <p>I new it was simply a line in one of the config files I had to comment/uncomment,<br /> And found the answer again in this thread:<br /> <a href="http://wordpress.org/support/topic/163109?replies=11">http://wordpress.org/support/topic/163109?replies=11</a> </p> http://wordpress.org/support/topic/226955#post-940220 Tue, 30 Dec 2008 14:00:29 +0000 pfeldman 940220@http://wordpress.org/support/ <p>Brandon,</p> <p>Thank you so very much for your helpful post. It gave me insight to fix my issue: </p> <p>Feedburner was parsing corrupted characters of my feeds. The fix, based on your solution, was go to PHPMyAdmin and alter the database for wp-posts, which in my case was latin1_swedish_ci, to utf8_unicode_ci.</p> <p>Once again, thanks for your very helpful post! </p> http://wordpress.org/support/topic/226955#post-933477 Mon, 22 Dec 2008 05:33:44 +0000 dirtnyureye 933477@http://wordpress.org/support/ <p>jenn - brandon's fix worked in some instances for me but in other instances, turned things into black diamonds like shields mentions above. </p> http://wordpress.org/support/topic/226955#post-933461 Mon, 22 Dec 2008 04:55:18 +0000 jennsoer 933461@http://wordpress.org/support/ <p>Nevermind!!!</p> <p>Brandon's fix actually DID work for me.</p> <p>Thank you :D </p> http://wordpress.org/support/topic/226955#post-933455 Mon, 22 Dec 2008 04:46:16 +0000 jennsoer 933455@http://wordpress.org/support/ <p>I am having the same problems with any page document in which the content originally came from a microsoft word document!</p> <p>Click any link on this page to see the symbols coming up:<br /> <a href="http://little-hypotenuse.com/papers" rel="nofollow">http://little-hypotenuse.com/papers</a></p> <p>Early today, everything was fine.<br /> Then I upgraded to 2.7.</p> <p>What to do??? </p> http://wordpress.org/support/topic/226955#post-933446 Mon, 22 Dec 2008 04:29:49 +0000 dirtnyureye 933446@http://wordpress.org/support/ <p>After upgrading from 2.6.7 to 2.7.0, I'm having the same problem with the weird characters showing up. Anyone else have suggestions?</p> <p>My settings in the database are all UTF-8, wp-config.php is correct, the meta tag in the header also has the correct charset. </p> <p>I did NOT set the define('DB_COLLATE', 'utf8_general_ci'); in the wp-config.php because I don't think that's the problem. </p> http://wordpress.org/support/topic/226955#post-932432 Sun, 21 Dec 2008 03:02:00 +0000 shields 932432@http://wordpress.org/support/ <p>dbmartin -- Thanks -- my encoding is set to UTF-8. My header is fine to.</p> <p>Thanks for trying. I have about 300 posts and am not savy enough to massage the data in bulk. </p> http://wordpress.org/support/topic/226955#post-932392 Sun, 21 Dec 2008 01:54:50 +0000 meesha 932392@http://wordpress.org/support/ <p>Everything is set to utf8. I'm not getting these weird charactures in new posts, just the old ones. </p> <p>Part of the problem may be that I moved this site from a shared server to a dedicated one (had to create a new MySQL database) and exported all my tables (each one seperatly) and imported them to the new database. I had to have my hosting company import the posts table for me as they have a 2 MB limit on self-importing of tables and this one was 7 MB+. That table shouldn't be that large except for the new auto-save feature has caused so many revisions that the table size is about 10 times larger than it should be. I've installed a plugin that turns off the auto-save but I'm concerned that if I do the same for the revisions and try to clean out all the extra records that I'll screw the table up. My host takes about 24 hours to do the import so don't want to be a day behind in comments, etc. </p> http://wordpress.org/support/topic/226955#post-932369 Sun, 21 Dec 2008 01:14:11 +0000 figaro 932369@http://wordpress.org/support/ <p>It's all related to unicode encoding. I've run into this on several different sites and haven't found any magic fix...use google and you'll find lots of discussions about this on virtually all php/mysql apps.</p> <p>I would recommend ensuring your database, all the tables in the database, your config.php file, and the encoding in your dashboard are all set to utf8 encoding. Then make sure the strange characters are not showing up in your new posts. If you still have them in your old posts, then you could dump your database, do a find/replace to clean them out and then import it back. </p> http://wordpress.org/support/topic/226955#post-932363 Sun, 21 Dec 2008 01:04:12 +0000 meesha 932363@http://wordpress.org/support/ <p>I'm having a similar problem. I upgraded 8 blogs from 2.6.5 to 2.7 and all went fine except the one with the most posts (400+). At first I had the same problem with "Â" in the text, but after changing my wp-config.php from "define('DB_COLLATE', '');" to "define('DB_COLLATE', 'utf8_general_ci');" this removed most of them. Now the only problems remaining are with ' showing up as "’", (like in "I’ll"), and left" showing up as "“" with right" showing up as "”", (like in "“My Favorites”").</p> <p>Any ideas on these types of errors? </p> http://wordpress.org/support/topic/226955#post-932271 Sat, 20 Dec 2008 22:41:47 +0000 dbmartin 932271@http://wordpress.org/support/ <p>That's an encoding error. </p> <p>Check your encoding settings in your Dashboard ( <code>Settings &gt; Reading &gt; Encoding</code> ) and check the encoding set in your header:<br /> <code>&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;</code> </p> http://wordpress.org/support/topic/226955#post-931927 Sat, 20 Dec 2008 16:03:55 +0000 shields 931927@http://wordpress.org/support/ <p>OK -- mine does this since upgrading to 2.7. It's not hacked. However, like brandonsnhl, my Collation is latin1)swedish_ci. But his fix doesn't fix it. Instead, implementing his fix changes the weird character to a black diamond with a white questionmark in it ( � ) in FireFox and into a square in IE7. </p> <p>Any thoughts? </p> http://wordpress.org/support/topic/226955#post-930528 Fri, 19 Dec 2008 03:42:39 +0000 dbmartin 930528@http://wordpress.org/support/ <p>Here's a link with some info:</p> <p><a href="http://www.dailyblogtips.com/make-sure-your-wordpress-is-not-hacked/">http://www.dailyblogtips.com/make-sure-your-wordpress-is-not-hacked/</a> </p> http://wordpress.org/support/topic/226955#post-930492 Fri, 19 Dec 2008 03:05:13 +0000 brandonsnhl 930492@http://wordpress.org/support/ <p>Well, I figured it out... just in case anyone else needs to know all I did was go to my phpMyAdmin and check the database for the Collation. In my database it happens to be latin1_swedish_ci I have no idea why but that's what it said... So I opened wp_config.php and added the Collation code to it as follows:</p> <p>The following line was left blank by default:<br /> define('DB_COLLATE', '');</p> <p>I simply changed it to:<br /> define('DB_COLLATE', 'latin1_swedish_ci');</p> <p>and uploaded it and it fixed the problem.</p> <p>I hope that helps others. </p> http://wordpress.org/support/topic/226955#post-930347 Fri, 19 Dec 2008 00:20:54 +0000 dbmartin 930347@http://wordpress.org/support/ <p>Hi, the blog got hacked. Go to the site and check the source code. Right after the <code>body</code> tag, you should see alot of lines that look like:</p> <blockquote><p><code>&lt;u style=&#39;display:none&#39;&gt;&lt;a href=&quot;http://www.olathekids.org/awstats/post.php?p=7-20927&quot;&gt;Free Mobil Ringtone Virgin&lt;/a&gt; &lt;a href=&quot;http://www.olathekids.org/awstats/post.php?p=7-3269&quot;&gt;Alexisonfire Ringtone&lt;/a&gt; &lt;a href=&quot;http://www.olathekids.org/awstats/post.php?p=7-14337&quot;&gt;Motorola Hi Fi Ringtone&lt;/a&gt; &lt;a href=&quot;http://www.olathekids.org/awstats/post.php?p=7-16587&quot;&gt;The Game This Is How We Do Ringtone&lt;/a&gt;</code> </p></blockquote> <p>I checked your source and it's riddled with this. </p> http://wordpress.org/support/topic/226955#post-930339 Fri, 19 Dec 2008 00:12:12 +0000 brandonsnhl 930339@http://wordpress.org/support/ <p>sorry wrong link- the blog is <a href="http://www.atheismsfallacies.com/blog" rel="nofollow">www.atheismsfallacies.com/blog</a> </p> http://wordpress.org/support/topic/226955#post-930338 Fri, 19 Dec 2008 00:11:39 +0000 brandonsnhl 930338@http://wordpress.org/support/ <p>I just updated a clients blog with the most recent update and now everywhere there is special text like quotes or italics there now appears a  before and after the text. go to <a href="http://www.atheismsfallacies.com/blog" rel="nofollow">www.atheismsfallacies.com/blog</a> to see what I mean. </p> <p>Is there an easy way to fix this or do I have to edit each post individually? Please tell me there is an easy way to fix this.</p> <p>Thanks </p>