Characters?
Moderator: General Support Moderators
-
- Joomla! Apprentice
- Posts: 9
- Joined: Wed Apr 14, 2010 5:19 pm
Re: Â Characters?
The characters are in the Database. I just don't know the proper syntax to remove them in my case.
- infograf768
- Joomla! Master
- Posts: 19133
- Joined: Fri Aug 12, 2005 3:47 pm
- Location: **Translation Matters**
Re: Â Characters?
You have to get rid of the windows charset in your template index.php on one hand.AlexDontKnow wrote:soldatenhund wrote:
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" />
.
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.
Jean-Marie Simonet / infograf
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
-
- Joomla! Apprentice
- Posts: 9
- Joined: Wed Apr 14, 2010 5:19 pm
Re: Â Characters?
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?
-
- Joomla! Apprentice
- Posts: 16
- Joined: Wed Mar 03, 2010 3:37 pm
Re: Â Characters?
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:
Joe
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:
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).infograf768 wrote:Except for the fact that your text abuses of non breaking spaces next to normal spaces, I do not understand this behavior.
Could you clean-up your code and take of one of the spaces where they are together?Code: Select all
Once again! VOLUNTEERS! PLEASE PARK OFF-CAMPUS!</p>
Which version of Joomla?
Which text editor?
Is your database full utf8?
Joe
- SallyR
- Joomla! Enthusiast
- Posts: 118
- Joined: Wed Nov 12, 2008 1:35 am
- Location: Florida, USA
- Contact:
Re: Â Characters?
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???
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???
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sun Aug 28, 2011 4:08 am
Re: Â Characters?
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
Tomas
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Oct 29, 2011 5:34 am
Re: Â Characters?
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.
-
- Joomla! Fledgling
- Posts: 4
- Joined: Tue Oct 05, 2010 11:45 am
Re: Â Characters?
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.
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
- Joomla! Guru
- Posts: 692
- Joined: Thu Aug 18, 2005 10:32 am
- Location: United Kingdom
- Contact:
Re: Â
This may also be related to changes in PHP 5.4. Please see - http://joomlacode.org/gf/project/joomla ... m_id=29944
just because you're not paranoid, doesn't mean everybody isn't out to get you.
http://www.maketradefair.org
http://www.maketradefair.org
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sun Jul 28, 2013 10:26 pm
Re: Â
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.
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.
You do not have the required permissions to view the files attached to this post.
-
- Joomla! Apprentice
- Posts: 45
- Joined: Wed Jul 31, 2013 6:43 am
Re: Â
The collation shall be "utf8_general_ci" or "utf8_unicode_ci" fore the database in Joomla 1.5!?infograf768 wrote:If you give me access to your site (superadmin, phpmyadmin, ftp), I could have a look.chandu4ugandhi wrote: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
- wernejo
- Joomla! Enthusiast
- Posts: 231
- Joined: Sun Jun 17, 2007 9:17 am
- Location: Australia
- Contact:
Re: Â
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?
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
- Joomla! Master
- Posts: 19133
- Joined: Fri Aug 12, 2005 3:47 pm
- Location: **Translation Matters**
Re: Â Characters?
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 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
Jean-Marie Simonet / infograf
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
- wernejo
- Joomla! Enthusiast
- Posts: 231
- Joined: Sun Jun 17, 2007 9:17 am
- Location: Australia
- Contact:
Re: Â
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.infograf768 wrote: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'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.
-
- I've been banned!
- Posts: 27
- Joined: Sat Apr 13, 2013 5:49 am
Re: Â Characters?
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
- Joomla! Ace
- Posts: 1088
- Joined: Wed Feb 20, 2008 6:50 am
- Location: Canada, Montreal
- Contact:
Re: Â Characters?
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...
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
- Joomla! Ace
- Posts: 1088
- Joined: Wed Feb 20, 2008 6:50 am
- Location: Canada, Montreal
- Contact:
Re: Â Characters?
In that case, when I add the “È” character in ACOUPÈNE in this article - The problem occurs ?
-
- Joomla! Apprentice
- Posts: 12
- Joined: Mon Aug 26, 2013 6:39 pm
Re: Â Characters?
hi Chacapamac!Chacapamac wrote:In that case, when I add the “È” character in ACOUPÈNE in this article - The problem occurs ?
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/