Characters?

[soldatenhund]

The characters are in the Database. I just don't know the proper syntax to remove them in my case.

[infograf768]

So i can't find the problem in my index.php says both

<meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
.

You have to get rid of the windows charset in your template index.php on one hand.
On the other hand you have to make sure as was stated MANY times on these forums, that your database is collated UTF8, the tables same and the fields in the tables also.
For this, use PHPMyadmin or Phoca script as explained above.

[soldatenhund]

My collation is correct in the DB, when I search for the character I find it in the DB. I'll check the windows charset in the template. but if it is in the DB how do I remove it?

[mazacini]

Hi

I'm having this problem when I export my databse from my webserver, and copy it into my local host. The  appears on the localhost, even though the live web version was originally copied from localhost, and localhost did not display this character until I transferred back from live web version. Also, text ..... appears as …â€

From history of this thread, problem seems to mainly relate to utf-8 settings. For my Website (phpmyadmin) settings are:MySQL charset and MySQL connection collation are both UTF-8 Unicode.

However, another source of this problem seems to be the incorrect use of spaces in content. I refer to this from "infograf" Nov 2008:

Except for the fact that your text abuses of non breaking spaces next to normal spaces, I do not understand this behavior.

Code: Select all

Once again!&nbsp; VOLUNTEERS!&nbsp; PLEASE PARK OFF-CAMPUS!</p>

Could you clean-up your code and take of one of the spaces where they are together?
Which version of Joomla?
Which text editor?
Is your database full utf8?

My questions: What is causing this behaviour? If I am abusing rules regarding text / spaces, what are these rules? (Remember, I am completely non-technical).

Joe

[SallyR]

I just got this problem with a recent copy of my live joomla site. My server hosting company copied the files and database to a new server on a temporary domain and once I test it, I will switch the joomla on the new server to my old domain

Here is my live site without the the odd  characters www.officialfanclub.net
Here is the recently copied stie www.officialfanclub.info

The content on both domains is 100% identical. The only change I made was pointing the configuration.php to the new database name and server. I did not change anything in the administrator, no new files, nothing else. Very odd.

I cannot switch to this new server until this is resolved. Any ideas???

[tomasksolomon]

I had the same issue. The problem I had was caused by my database. My MySQL connection collation was configured to accept UTF8_Unicode_ci text and I had copied and pasted text from a wordPad to my sql query to create tables. The work around I came up with was using text from a notepad instead of wordpad. Therefore, the simple answer is if you are using workpad, ms word or other formatted text to create your tables in MySQL then try using plain text.

Tomas

[rickb928]

This problem jus came up out of the blue on my site. System Cache was disabled, and enabling it fixed the problem, for now. I'll be checking on this over the next few days.

[xyzt]

Updating JoomFish helpen over here!

[jamesreed]

SOLVED! had the same problem, clear the cache the character disappear, but refresh and the weird A's randomly appear again, mostly where the UK pound(£) symbol was used.

I always do mysqldump with --default-character-set=latin1 so my problem wasn't the characters in the database, as that fixes that.

My solution was to:
1) run the Phoca tool on the database.
2) add to the local php.ini file:
default_charset = "utf-8"

on phpinfo() it says the master setting is UTF8, but forcing the local to be UTF8 is what sorted things out!
Thanks for the phoca script tip.

[happy_noodle_boy]

This may also be related to changes in PHP 5.4. Please see - http://joomlacode.org/gf/project/joomla ... m_id=29944

[Monia1214]

I think I found The Solution for me means it worked
I have PHP version 5.4, I found a solution to one of the forums below link (2 post from the end) attachment below.

http://www.jevents.net/forum/viewtopic.php?f=29&t=17668

Let me know if helped. Yours.

[filim]

Hello

I have checked all the database tables.

All table's collation is "utf8_general_ci".

Then what is the problem with it.

Why it is showing that type of character on the front main page?

Chandu

If you give me access to your site (superadmin, phpmyadmin, ftp), I could have a look.

The collation shall be "utf8_general_ci" or "utf8_unicode_ci" fore the database in Joomla 1.5!?

[wernejo]

Hi everyone,

i've just had this issue appear out of nowhere on two websites that have been running just fine for the last 2 years. both websites run joomla 1.5 and jce.

the only thing that i can find to link these to websites is the fact that both are been managed by people using safari. but why would these two perfectly healthy websites start playing up like this for no reason?

none of the websites have been moved from different hosts or anything that would require changes to the sql database. could this be something to do with jce and safari?

[infograf768]

Unrelated imho to safari and JCE. Easy to test by using another browser and unpublishing JCE.

I would rather consider a change done by your host wothout your knowledge.
Also, 1.5 is now obsolete. I suggest you move to 2.5

[wernejo]

Unrelated imho to safari and JCE. Easy to test by using another browser and unpublishing JCE.

I would rather consider a change done by your host wothout your knowledge.
Also, 1.5 is now obsolete. I suggest you move to 2.5

i do agree with what you're saying about the upgrade but unfortunately it isn't really an option due to the cost of building a new website.


I've tested the browsers and haven't had any issues even when using the same browser as my clients use for when they do their updates. the other thing is that its only happening in one article and not the whole website.

is there any solutions i could try apart from changing jce? i am currently trying one website without jce to see if that works.

[rutin]

I'm working with a few of my other users on Gmail whose emails always have the  symbol to see if them changing their Gmail to UTF-8 will solve the problem. I'll let you know.

[Chacapamac]

Brand new 3.3.6 with same type of problems ?

http://www.monacouphene.ca/traitements

Seem the only page in the site causing a problem

Infograf, if you want to take a look I have no problem...

[Chacapamac]

In that case, when I add the “È” character in ACOUPÈNE in this article - The problem occurs ?

[tenia]

In that case, when I add the “È” character in ACOUPÈNE in this article - The problem occurs ?

hi Chacapamac!
please see:

Code: Select all

http://www.theasciicode.com.ar/extended-ascii-code/letter-e-grave-accent-ascii-code-138.html
http://www.utf8-chartable.de/