Problem with greek and cyrillic characters in Fireboard
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
It is pretty strange, I work on 1.5 Joomla with latin collation and Cyrillic and have no problems, where is the difference between the armenian and the rest?
- aravot
- Joomla! Ace
- Posts: 1015
- Joined: Thu Aug 18, 2005 1:16 am
- Location: Glendale, CA, USA
- Contact:
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
Yes, every alphabet is different, but it is not a reason something to not work. Can you give me an example of 1.5 installed on MySQL with collation latin for example?
Ivo
Ivo
- aravot
- Joomla! Ace
- Posts: 1015
- Joined: Thu Aug 18, 2005 1:16 am
- Location: Glendale, CA, USA
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Let me install it on a live site, will PM you the link once done (won't be today)
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
OK, I am performing a test on that right now. Can you PM me any page that has massive Armenian text on it.
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
Ahhhh, now I get the issue.
1. During installation Joomla! attempts to change the database collation to utf8_general_ci, but from my past experience (pre Beta2) this was not always successful (need to perform additional tests on that).
2. If Joomla! makes it to change the database collation to utf8_general_ci, there are no issues at all.
3. If Joomla! doesn't makes it, problems start to appear with 3PD extensions, because in their queries usually there is no collation set. This is pretty normal as in 1.0.x series we expect the component to work with any collation and to take the database default collation (which is supposed to be correct). In the Joomla! 1.5 SQL files you can find the following code:
which makes everything to work excellent with the core staff, but is missing in 1.0.x extensions and causes problems.
I performed a test regarding the Armenian staff and the report of it can be found at:
http://armenian.yantra.biz/TestReport.pdf
In this particular case, Joomla! was able to change the database collation from latin1_swedish_ci to utf8_general_ci, but I am not really sure if it works all the time and.
So if the questions is: Does Joomla! require the database collation to be utf8_general_ci?
And the answer: Joomla! 1.5 itself doesn't require that, but its current extensions DO.
Edit: Typos
1. During installation Joomla! attempts to change the database collation to utf8_general_ci, but from my past experience (pre Beta2) this was not always successful (need to perform additional tests on that).
2. If Joomla! makes it to change the database collation to utf8_general_ci, there are no issues at all.
3. If Joomla! doesn't makes it, problems start to appear with 3PD extensions, because in their queries usually there is no collation set. This is pretty normal as in 1.0.x series we expect the component to work with any collation and to take the database default collation (which is supposed to be correct). In the Joomla! 1.5 SQL files you can find the following code:
Code: Select all
TYPE=MyISAM CHARACTER SET `utf8`
I performed a test regarding the Armenian staff and the report of it can be found at:
http://armenian.yantra.biz/TestReport.pdf
In this particular case, Joomla! was able to change the database collation from latin1_swedish_ci to utf8_general_ci, but I am not really sure if it works all the time and.
So if the questions is: Does Joomla! require the database collation to be utf8_general_ci?
And the answer: Joomla! 1.5 itself doesn't require that, but its current extensions DO.
Edit: Typos
Last edited by ivo.apostolov on Thu May 31, 2007 1:56 am, edited 1 time in total.
- aravot
- Joomla! Ace
- Posts: 1015
- Joined: Thu Aug 18, 2005 1:16 am
- Location: Glendale, CA, USA
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Ivo thanks for testing this.
- yvolk
- Joomla! Guru
- Posts: 979
- Joined: Thu Jun 01, 2006 1:52 pm
- Location: Moscow, Russia
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Ivo, it is VERY easy to reproduce the problem:ivo.apostolov wrote: There is no issue with it (if else and someone encounters issues with it please post details here). What I mean is that the database collation could be latin, windows Cyrillic or anything, but Joomla! API saves and gets the information from there as UTF.
1. Install Joomla 1.5 beta 2, creating new database with "latin1-general-ci" collation (this is what users get by default!)
2. Open the site
3. Login as Admin, go to the menu "Menus"->"Main Menu"
4. Click "The News" Menu Item.
5. Change "Title:" field from "The News" to "Новини"
6. Press "Save" button.
7. See, what you get in the menu item's title ("? ? ? ? ? ?")
8. Reopen The bug tracker Item
Last edited by yvolk on Thu May 31, 2007 1:28 pm, edited 1 time in total.
Text of all my messages is available under the terms of the GNU Free Documentation License: http://www.gnu.org/copyleft/fdl.html
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
Yuri, I did that already, I pretty fine get the issue at the moment, but the idea was how to explain it to the dev team.
- yvolk
- Joomla! Guru
- Posts: 979
- Joined: Thu Jun 01, 2006 1:52 pm
- Location: Moscow, Russia
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Maybe, my above posted sequence of steps to reproduce the bug is enough?ivo.apostolov wrote: Yuri, I did that already, I pretty fine get the issue at the moment, but the idea was how to explain it to the dev team.
I don't know exactly, what "collation" in MySQL Server means (and I don't think I need to know in this case), but the "collation" may be checked and changed through common tools (MySqlAdmin...) and "wrong collation" leads to the error, that may be easily reproduced.
Text of all my messages is available under the terms of the GNU Free Documentation License: http://www.gnu.org/copyleft/fdl.html
- Jinx
- Joomla! Champion
- Posts: 6508
- Joined: Fri Aug 12, 2005 12:47 am
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Guys,
Hold your horses here, this is not a collation problem it's a character set problem. Collation only defines sorting order it does not define the actual database data. What happens with 1.0 extensions is that they need to change their installation script and add a install.utf.sql (for MySQL 4.0.17 and up) and install.nonutf.sql file (for lower then MySQL 4.0.17). The only difference between both is that for the install.utf.sql you need tp set the table charset to utf8 using :
This is all carefully explained on the wiki : http://dev.joomla.org/component/option, ... nes:utf-8/
Hope this helps to shed a light on the issue.
Johan
Hold your horses here, this is not a collation problem it's a character set problem. Collation only defines sorting order it does not define the actual database data. What happens with 1.0 extensions is that they need to change their installation script and add a install.utf.sql (for MySQL 4.0.17 and up) and install.nonutf.sql file (for lower then MySQL 4.0.17). The only difference between both is that for the install.utf.sql you need tp set the table charset to utf8 using :
Code: Select all
CHARSET=utf8
Hope this helps to shed a light on the issue.
Johan
Johan Janssens - Joomla Co-Founder, Lead Developer of Joomla 1.5
http://www.joomlatools.com - Joomla extensions that just work
http://www.joomlatools.com - Joomla extensions that just work
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
Johan,
two questions came up here:
1. If it is not a collation, but encoding, why it is written as collation in phpMyAdmin? Is this some kind of misunderstanding there? Just don't get it. You say it's encoding, but phpMyAdmin says it is collation.
2. What you basically say is that whatever the encoding of the database (which is mentioned in the above posts and understood as "collation") is not utf8, the 1.0 extensions all need re-write even to work in legacy mode?
3. Is Joomla! changing the database encoding (or what we understand as "collation") to utf8 during installation?
Thanks
Edit: Attaching two screenshots, where in phpMyAdmin, the value that is actually the one controlling how the data is stored is named collation
two questions came up here:
1. If it is not a collation, but encoding, why it is written as collation in phpMyAdmin? Is this some kind of misunderstanding there? Just don't get it. You say it's encoding, but phpMyAdmin says it is collation.
2. What you basically say is that whatever the encoding of the database (which is mentioned in the above posts and understood as "collation") is not utf8, the 1.0 extensions all need re-write even to work in legacy mode?
3. Is Joomla! changing the database encoding (or what we understand as "collation") to utf8 during installation?
Thanks
Edit: Attaching two screenshots, where in phpMyAdmin, the value that is actually the one controlling how the data is stored is named collation
You do not have the required permissions to view the files attached to this post.
Last edited by ivo.apostolov on Thu May 31, 2007 1:59 pm, edited 1 time in total.
- Jinx
- Joomla! Champion
- Posts: 6508
- Joined: Fri Aug 12, 2005 12:47 am
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Oke I'll try to explain, we are talking about two diferent things here :
1. Character set = the character set of a database/table defines the encoding for that database/table, for Joomla! 1.5 to work with all languages this needs to be set to utf8.
2. Collation = the collation of the database/table defines the sorting order when sort queries are preformed, this is because in different languages letters are sorted differently.
Both are two different settings and should not be confused. The problem we are talking about here is character set not collation. If your collation isn't set correctly it does not have any effect on the output of the data, it can only have an effect on sorting.
The problem with the character set is that Joomla! 1.5 needs it to be utf8, and to make sure it is utf8 it forces the charcater set to utf8 on a per table basis. Joomla! 1.0 on the other hand does not care about the character set of a table and relies on the global character set for the whole database.
Joomma! 1.0 extensions will work in 1.5 as expected. Meaning that they will not support all langauges, this is the same situation as in 1.0. If a extension developer want to support full internationalisation he needs to make a small change to his installation script as explained in the link i provided above. This change is BC and does not have any effect on Joomla! 1.0.
So to answer your questions :
1. It's not collation, but character set. phpMyAdmin mentions only the collation for each table, the character set can only be set on a per table basis since MySQL 4.0.17. I'm unsure if the newer version of phpMyAdmin already support this.
2. As explained collation and character set are two different settings with different usage. If the character set of the table is not set to utf8 then problem will occur with international langauges. To make sure it is set to utf8 a extension needs to force it's tables to utf8 using a special sql script as explained in the link. If it doesn't the situation will be the same as in Joomla! 1.0, meaning it could work depending on the setting of the database or it could fail.
3. It's a bit more complicated then that since 1.5 supports all MySQL versions. But simply said Joomla! 1.5 is forcing the character set for the database to utf8, this happens dynamically by the database driver.
1. Character set = the character set of a database/table defines the encoding for that database/table, for Joomla! 1.5 to work with all languages this needs to be set to utf8.
2. Collation = the collation of the database/table defines the sorting order when sort queries are preformed, this is because in different languages letters are sorted differently.
Both are two different settings and should not be confused. The problem we are talking about here is character set not collation. If your collation isn't set correctly it does not have any effect on the output of the data, it can only have an effect on sorting.
The problem with the character set is that Joomla! 1.5 needs it to be utf8, and to make sure it is utf8 it forces the charcater set to utf8 on a per table basis. Joomla! 1.0 on the other hand does not care about the character set of a table and relies on the global character set for the whole database.
Joomma! 1.0 extensions will work in 1.5 as expected. Meaning that they will not support all langauges, this is the same situation as in 1.0. If a extension developer want to support full internationalisation he needs to make a small change to his installation script as explained in the link i provided above. This change is BC and does not have any effect on Joomla! 1.0.
So to answer your questions :
1. It's not collation, but character set. phpMyAdmin mentions only the collation for each table, the character set can only be set on a per table basis since MySQL 4.0.17. I'm unsure if the newer version of phpMyAdmin already support this.
2. As explained collation and character set are two different settings with different usage. If the character set of the table is not set to utf8 then problem will occur with international langauges. To make sure it is set to utf8 a extension needs to force it's tables to utf8 using a special sql script as explained in the link. If it doesn't the situation will be the same as in Joomla! 1.0, meaning it could work depending on the setting of the database or it could fail.
3. It's a bit more complicated then that since 1.5 supports all MySQL versions. But simply said Joomla! 1.5 is forcing the character set for the database to utf8, this happens dynamically by the database driver.
Johan Janssens - Joomla Co-Founder, Lead Developer of Joomla 1.5
http://www.joomlatools.com - Joomla extensions that just work
http://www.joomlatools.com - Joomla extensions that just work
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
Everything seems to be pretty fine and understandable, I read careful the wiki entry as well.
So, if encoding is set on per table basis, I can see that when in the SQL queries there is no encoding defined (ie charset=utf8), MySQL is creating the table with encoding that is the same to the database collation. So here comes the question, is Joomla! able to change the collation of the database during the installation? My test above show that it does ..., just not pretty sure if it works all the time.
So, if you say that the collation has nothing to do with how data is stored, I would agree definitely, but it has impact on the encoding of new created tables where there is no charset in the query.
So it turns now more like a feature request: Can Joomla! change the database collation during installation and in that way we will void approx. 10,000 posts in the forum like "Pleasee heeelp, strange chars appear"
Edit: 10 typos
So, if encoding is set on per table basis, I can see that when in the SQL queries there is no encoding defined (ie charset=utf8), MySQL is creating the table with encoding that is the same to the database collation. So here comes the question, is Joomla! able to change the collation of the database during the installation? My test above show that it does ..., just not pretty sure if it works all the time.
So, if you say that the collation has nothing to do with how data is stored, I would agree definitely, but it has impact on the encoding of new created tables where there is no charset in the query.
So it turns now more like a feature request: Can Joomla! change the database collation during installation and in that way we will void approx. 10,000 posts in the forum like "Pleasee heeelp, strange chars appear"
Edit: 10 typos
Last edited by ivo.apostolov on Thu May 31, 2007 2:39 pm, edited 1 time in total.
- yvolk
- Joomla! Guru
- Posts: 979
- Joined: Thu Jun 01, 2006 1:52 pm
- Location: Moscow, Russia
- Contact:
Re: Problem with greek and cyrillic characters
Hi, Johan!
Let's start from empty list
1. I think we shall return from terminology to the problem, visible to the users:
"Greek and Cyrillic characters, stored in Joomla! database, appear as boxes or question marks"
(Note, that we don't mention any extension here!)
2. This problem is simple to reproduce, because it affects Joomla! core functions, so there is no need to install any extention.
1. Install Joomla 1.5 beta 2, creating new database
2. Open the site
3. Login as Admin, go to the menu "Menus"->"Main Menu"
4. Click "The News" Menu Item.
5. Change "Title:" field from "The News" to "Новини"
6. Press "Save" button.
7. See, what you get in the menu item's title ("? ? ? ? ? ?")
Note: It was observed, that if the above bug reveals itself, User may see, using "phpMyAdmin" tool,
that all tables in Joomla's database have "latin1-general-ci" value in the column named "collation".
To reproduce the bug, if it doesn't appear during above scenario, do the following:
1. Create database manually before installation with "collation"="latin1-general-ci" (phpMyAdmin v.2.9.1.1 has this "collation" listbox in the "Create new database" form).
2. Use this existing database in the above scenario.
May you tell us simple thing:
1. Does Dev team know about this bug and confirms it?
Let's start from empty list
1. I think we shall return from terminology to the problem, visible to the users:
"Greek and Cyrillic characters, stored in Joomla! database, appear as boxes or question marks"
(Note, that we don't mention any extension here!)
2. This problem is simple to reproduce, because it affects Joomla! core functions, so there is no need to install any extention.
1. Install Joomla 1.5 beta 2, creating new database
2. Open the site
3. Login as Admin, go to the menu "Menus"->"Main Menu"
4. Click "The News" Menu Item.
5. Change "Title:" field from "The News" to "Новини"
6. Press "Save" button.
7. See, what you get in the menu item's title ("? ? ? ? ? ?")
Note: It was observed, that if the above bug reveals itself, User may see, using "phpMyAdmin" tool,
that all tables in Joomla's database have "latin1-general-ci" value in the column named "collation".
To reproduce the bug, if it doesn't appear during above scenario, do the following:
1. Create database manually before installation with "collation"="latin1-general-ci" (phpMyAdmin v.2.9.1.1 has this "collation" listbox in the "Create new database" form).
2. Use this existing database in the above scenario.
May you tell us simple thing:
1. Does Dev team know about this bug and confirms it?
Last edited by yvolk on Thu May 31, 2007 3:17 pm, edited 1 time in total.
Text of all my messages is available under the terms of the GNU Free Documentation License: http://www.gnu.org/copyleft/fdl.html
- Jinx
- Joomla! Champion
- Posts: 6508
- Joined: Fri Aug 12, 2005 12:47 am
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
As explained this is where the install.utf8.sql scripts come in for the extensions. For the core this is done by the installer.ivo.apostolov wrote: So, if encoding is set on per table basis, I can see that when in the SQL queries there is no encoding defined (ie charset=utf8), MySQL is creating the table with encoding that is the same to the database collation. So here comes the question, is Joomla! able to change the collation of the database during the installation? My test above show that it does ..., just not pretty sure if it works all the time.
Collation should not have any impact on the encoding of newly created tables. Collation and character set are two complete seperate settings.So, if you say that the collation has nothing to do with how data is stored, I would agree definitely, but it has impact on the encoding of new created tables where there is no charset in the query.
Again you are mixing up collation with character set, Joomla! 1.5 forces the character set to utf8 for all core tables, for extensions this needs to happen by the extension itself when it is installed.So it turns now more like a feature request: Can Joomla! change the database collation during installation and in that way we will void approx. 10,000 posts in the forum like "Pleasee heeelp, strange chars appear"
Joomla! cannot set the collation of the database itself, it relies on the predefined collation. If you need a different collation you can always changes this by hand. Again collation does not have any major effects on your system it only defines sorting order and it will not corrupt data.
Johan Janssens - Joomla Co-Founder, Lead Developer of Joomla 1.5
http://www.joomlatools.com - Joomla extensions that just work
http://www.joomlatools.com - Joomla extensions that just work
- Jinx
- Joomla! Champion
- Posts: 6508
- Joined: Fri Aug 12, 2005 12:47 am
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
I have tried to replicate this on two different local installation and it all works fine here. Can you start by giving me your MySQL version and the Joomla! 1.5 version you are ruhnning ?yvolk wrote: ".May you tell us simple thing:
1. Does Dev team know about this bug and confirms it?
Johan Janssens - Joomla Co-Founder, Lead Developer of Joomla 1.5
http://www.joomlatools.com - Joomla extensions that just work
http://www.joomlatools.com - Joomla extensions that just work
-
- I've been banned!
- Posts: 1868
- Joined: Thu Aug 25, 2005 2:33 pm
Re: Problem with greek and cyrillic characters in Fireboard
Johan,
believe me or not, but new tables except in the cases when the charset is specified in the SQL query are created with the same encoding as the database collation is. I need to sit down for a couple of hours and re-think the whole process.
believe me or not, but new tables except in the cases when the charset is specified in the SQL query are created with the same encoding as the database collation is. I need to sit down for a couple of hours and re-think the whole process.
- yvolk
- Joomla! Guru
- Posts: 979
- Joined: Thu Jun 01, 2006 1:52 pm
- Location: Moscow, Russia
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Of cause: all information is written in The bug tracker Item.Jinx wrote:I have tried to replicate this on two different local installation and it all works fine here. Can you start by giving me your MySQL version and the Joomla! 1.5 version you are running ?yvolk wrote: ".May you tell us simple thing:
1. Does Dev team know about this bug and confirms it?
(BTW, I've corrected that MySql tool name in above message, it is called "phpMyAdmin").
To reproduce the bug, if it doesn't appear during above scenario, do the following:
1. Create database manually before installation with "collation"="latin1-general-ci" (phpMyAdmin v.2.9.1.1 has this "collation" listbox in the "Create new database" form).
2. Use this existing database in the above scenario.
Text of all my messages is available under the terms of the GNU Free Documentation License: http://www.gnu.org/copyleft/fdl.html
- Jinx
- Joomla! Champion
- Posts: 6508
- Joined: Fri Aug 12, 2005 12:47 am
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
I'll investiagte.
Johan Janssens - Joomla Co-Founder, Lead Developer of Joomla 1.5
http://www.joomlatools.com - Joomla extensions that just work
http://www.joomlatools.com - Joomla extensions that just work
- infograf768
- Joomla! Master
- Posts: 19133
- Joined: Fri Aug 12, 2005 3:47 pm
- Location: **Translation Matters**
Re: Problem with greek and cyrillic characters in Fireboard
Anything new on this?
Jean-Marie Simonet / infograf
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group
- Jinx
- Joomla! Champion
- Posts: 6508
- Joined: Fri Aug 12, 2005 12:47 am
- Contact:
Re: Problem with greek and cyrillic characters in Fireboard
Yes, after some investigation we have discovered that this is a phpMyAdmin issue. phpMyAdmin is coupling character set and collaction, which makes sense.
Johan Janssens - Joomla Co-Founder, Lead Developer of Joomla 1.5
http://www.joomlatools.com - Joomla extensions that just work
http://www.joomlatools.com - Joomla extensions that just work
- infograf768
- Joomla! Master
- Posts: 19133
- Joined: Fri Aug 12, 2005 3:47 pm
- Location: **Translation Matters**
Re: Problem with greek and cyrillic characters in Fireboard
BTW, is'nt 2.1 in http://dev.joomla.org/component/option, ... tf-8/ obsolete?
As of now, we use
in joomla.sql
As of now, we use
Code: Select all
) TYPE=MyISAM CHARACTER SET `utf8`;
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! Intern
- Posts: 76
- Joined: Tue Oct 07, 2008 7:05 pm
Re: Problem with greek and cyrillic characters in Fireboard
hi all
I have a problem when install Extensions for joomla 1.5.7 like (fireboard)
all Tables in database take latin1_swedish_ci (Collation) when I write anything in arabic language I see it like this ??????????
MySQL charset is : UTF-8 Unicode (utf8)
can someone help me ?
I have a problem when install Extensions for joomla 1.5.7 like (fireboard)
all Tables in database take latin1_swedish_ci (Collation) when I write anything in arabic language I see it like this ??????????
MySQL charset is : UTF-8 Unicode (utf8)
can someone help me ?
-
- Joomla! Fledgling
- Posts: 3
- Joined: Sat Dec 20, 2008 1:20 am
Re: Problem with greek and cyrillic characters in Fireboard
Hi Guys,
I've read all the above but non of those solve my problem. The correct steps to have correct UTF-8 support is as follows:
Step 1.
Create the database from phpmyadmin interface with collation utf8_general_ci
Step 2.
Procced to Joomla installation
Step 3.
Open the file globals.php and at the end of it, right after the last
}
and right before
?>
put the following code:
header("Content-Type: text/html; charset=UTF-8");
Step 4.
Open the file language/english.php and go on line 421. Change the following code from:
DEFINE('_ISO','charset=iso-8859-1');
to:
DEFINE('_ISO','charset=UTF-8');
Step 5. ( and most importand for me )
Open the file includes/database.php and change the following code from:
// @mysql_query("SET NAMES 'utf8'", $this->_resource);
to:
@mysql_query("SET NAMES 'utf8'", $this->_resource);
THE END.
The last one solve my problem to transfer my site to a different server.
I Agree with the friend below, but this is the guide to make a sucssefull migration from Joomla 1.0.15 to Joomla 1.5.x. And also if you want to transfer site from on Web Hosting Server to another.
Regards.
I've read all the above but non of those solve my problem. The correct steps to have correct UTF-8 support is as follows:
Step 1.
Create the database from phpmyadmin interface with collation utf8_general_ci
Step 2.
Procced to Joomla installation
Step 3.
Open the file globals.php and at the end of it, right after the last
}
and right before
?>
put the following code:
header("Content-Type: text/html; charset=UTF-8");
Step 4.
Open the file language/english.php and go on line 421. Change the following code from:
DEFINE('_ISO','charset=iso-8859-1');
to:
DEFINE('_ISO','charset=UTF-8');
Step 5. ( and most importand for me )
Open the file includes/database.php and change the following code from:
// @mysql_query("SET NAMES 'utf8'", $this->_resource);
to:
@mysql_query("SET NAMES 'utf8'", $this->_resource);
THE END.
The last one solve my problem to transfer my site to a different server.
I Agree with the friend below, but this is the guide to make a sucssefull migration from Joomla 1.0.15 to Joomla 1.5.x. And also if you want to transfer site from on Web Hosting Server to another.
Regards.
Last edited by kmaliagkas on Tue Dec 23, 2008 12:55 pm, edited 1 time in total.
- infograf768
- Joomla! Master
- Posts: 19133
- Joined: Fri Aug 12, 2005 3:47 pm
- Location: **Translation Matters**
Re: Problem with greek and cyrillic characters in Fireboard
You are mixing Joomla 1.0 and Joomla 1.5
There is no language/english.php file in Joomla 1.5
There is no language/english.php file in Joomla 1.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
-
- Joomla! Fledgling
- Posts: 3
- Joined: Sat Dec 20, 2008 1:20 am
Re: Problem with greek and cyrillic characters in Fireboard
Hi,
I Agree with the friend above, but this is the guide to make a sucssefull migration from Joomla 1.0.15 to Joomla 1.5.x. And also if you want to transfer site from on Web Hosting Server to another.
In my little experience on Joomla 1.5 if you convert the tables in UTF-8, everithing work fine. The only think you may have to do is everithing you see in Symbols to write it again in your language.
Regards.
I Agree with the friend above, but this is the guide to make a sucssefull migration from Joomla 1.0.15 to Joomla 1.5.x. And also if you want to transfer site from on Web Hosting Server to another.
In my little experience on Joomla 1.5 if you convert the tables in UTF-8, everithing work fine. The only think you may have to do is everithing you see in Symbols to write it again in your language.
Regards.