I want to use the forum with a non-english language but i don't want to use the multilingual templates, they are very difficult to edit.
First of all i changed both wrappers to use 'UTF-8'. My database is set to utf8_unicode_ci. Although my language characters shows ok in the forum, phpmyadmin shows garbage. I searched a little and found a way to fix this by adding in mysql.php:
function db($dbhost, $dbuser, $dbpass, $databasename) { $this->dbh = mysql_connect($dbhost, $dbuser, $dbpass); if (!$this->dbh) return false; ////////// my code; mysql_query("SET NAMES 'utf8'", $this->dbh); //////////////////////////////////////////////////// mysql_select_db($databasename);
Not sure if this a bug or because i don't use the multilingual templates, so i am posting it just in case.
Please tell me if there is something wrong with this fix, before i start to use the forum for real. As far as i tested it, it works fine.
I'll need an example of the characters you're typing so that I can test it.
I want to use the forum with a non-english language but i don't want to use the multilingual templates, they are very difficult to edit.
Probably the quickest way is to do a multilingual install, then run the template translation after you've translated the language pack, then trim the language pack with the language page's "Clean out all unused items" option.
I'll need an example of the characters you're typing so that I can test it.
sample: "αγςρτγσεργ ρεσγσε γρεσγ"
Probably the quickest way is to do a multilingual install, then run the template translation after you've translated the language pack, then trim the language pack with the language page's "Clean out all unused items" option.
If i understand correctly, you mean how to translate the forum's language-pack from english to my language without using the multilingual templates. I don't want to do that, i will use the english language-pack. All i want is the forums/topics/posts text to be in my language using unicode.
I just found out that it only works if i use the plain editor. The fckeditor stores the post's message in database like "εεεσγ η"
I found a similar thread about this problem with fckeditor here, they didn't manage to fix it though.
Reply #9 seems to be a solution. Does setting FCKConfig.IncludeGreekEntities = false; not help you? It caches aggressively so you might need to check it in a different browser to be sure you're not getting a cache.
i will use the english language-pack.
My point was that doing so makes it take longer and makes it easier to miss something, and potentially complicates future upgrades.
Reply #9 seems to be a solution. Does setting FCKConfig.IncludeGreekEntities = false; not help you? It caches aggressively so you might need to check it in a different browser to be sure you're not getting a cache.
Yep it was the cache the problem. Works great now, thanks.
My point was that doing so makes it take longer and makes it easier to miss something, and potentially complicates future upgrades.
Just to be sure that we are talking about the same thing, what i want to do is to have all the menus and fixed-text of the forum in English. I want to show with Greek characters only the topics and posts, nothing else. Is it better to make a multilingual install in my case ?
The only thing i had to change so far, is the <IF {ISMULTILINGUAL}><meta http-equiv="Content-Type" content="text/html; charset={LANG_CHARSET};"></IF> in the admin wrapper.
I spoke too soon, there are still problems with some characters such as this one "Β". Although it is stored correctly in the database, if i edit the message the character shows garbage. Other characters create a space in each line of the message...
This fckthing is not meant to work with greek characters, i think i'll stick with the plain editor.
thanks
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on UTF issue
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
I want to use the forum with a non-english language but i don't want to use the multilingual templates, they are very difficult to edit.
First of all i changed both wrappers to use 'UTF-8'. My database is set to utf8_unicode_ci.
Although my language characters shows ok in the forum, phpmyadmin shows garbage.
I searched a little and found a way to fix this by adding in mysql.php:
function db($dbhost, $dbuser, $dbpass, $databasename)
{
$this->dbh = mysql_connect($dbhost, $dbuser, $dbpass);
if (!$this->dbh) return false;
////////// my code;
mysql_query("SET NAMES 'utf8'", $this->dbh);
////////////////////////////////////////////////////
mysql_select_db($databasename);
Not sure if this a bug or because i don't use the multilingual templates, so i am posting it just in case.
Please tell me if there is something wrong with this fix, before i start to use the forum for real. As far as i tested it, it works fine.
thanks
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I'll need an example of the characters you're typing so that I can test it.
I want to use the forum with a non-english language but i don't want to use the multilingual templates, they are very difficult to edit.
Probably the quickest way is to do a multilingual install, then run the template translation after you've translated the language pack, then trim the language pack with the language page's "Clean out all unused items" option.
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
I'll need an example of the characters you're typing so that I can test it.
sample: "αγςρτγσεργ ρεσγσε γρεσγ"
Probably the quickest way is to do a multilingual install, then run the template translation after you've translated the language pack, then trim the language pack with the language page's "Clean out all unused items" option.
If i understand correctly, you mean how to translate the forum's language-pack from english to my language without using the multilingual templates.
I don't want to do that, i will use the english language-pack. All i want is the forums/topics/posts text to be in my language using unicode.
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
I just found out that it only works if i use the plain editor. The fckeditor stores the post's message in database like
"εεεσγ η"
I found a similar thread about this problem with fckeditor here, they didn't manage to fix it though.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Reply #9 seems to be a solution. Does setting FCKConfig.IncludeGreekEntities = false; not help you? It caches aggressively so you might need to check it in a different browser to be sure you're not getting a cache.
i will use the english language-pack.
My point was that doing so makes it take longer and makes it easier to miss something, and potentially complicates future upgrades.
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
Reply #9 seems to be a solution. Does setting FCKConfig.IncludeGreekEntities = false; not help you? It caches aggressively so you might need to check it in a different browser to be sure you're not getting a cache.
Yep it was the cache the problem. Works great now, thanks.
My point was that doing so makes it take longer and makes it easier to miss something, and potentially complicates future upgrades.
Just to be sure that we are talking about the same thing, what i want to do is to have all the menus and fixed-text of the forum in English. I want to show with Greek characters only the topics and posts, nothing else.
Is it better to make a multilingual install in my case ?
The only thing i had to change so far, is the
<IF {ISMULTILINGUAL}><meta http-equiv="Content-Type" content="text/html; charset={LANG_CHARSET};"></IF>
in the admin wrapper.
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
I spoke too soon, there are still problems with some characters such as this one "Β".
Although it is stored correctly in the database, if i edit the message the character shows garbage.
Other characters create a space in each line of the message...
This fckthing is not meant to work with greek characters, i think i'll stick with the plain editor.
thanks