FUDforum: FUDforum in eGroupWare » Weird repsesentation of greek language

Home » General » FUDforum in eGroupWare » Weird repsesentation of greek language

Show: Today's Messages :: Polls :: Message Navigator

Weird repsesentation of greek language [message #25147]

Fri, 27 May 2005 15:41

foris

Messages: 3
Registered: May 2005

Karma: 0

Junior Member

Hi everyone!

I have installed eGroupWare on my personal PC in order to test it's abilities, as a tool for collaboration of people spread around the world. FudForum is more than essential to serve my purpose.

Though I'm not currently interested in translating the tool in greek, it's essential for me to be able to create forums and post messages in greek.

I tried it in my custom setup and got some weird results. When I try to create a new category with a greek title, the title entered is trimmed to the size of 10 characters. The description is shown as entered. Then, when I try to create a new forum under that category, the forum title is presented as a unicode string (i.e. Γειά) while the forum description is again shown as entered!

I am able though to post a message and create a topic in greek, without any problem.

Is there a specific limitation concerning the greek language?. Is it a matter of the database setup?

Any ideas will be greately appreciated! Thanks in advance.

PS The details of my setup are:
eGroupWare 1.0.0.006
FUDforum 2.6.0 (FUDeGW)
Win XP SP1
IIS/5.1
PHP v5.0.2
MySQL Server ver 4.1

Report message to a moderator

Re: Weird repsesentation of greek language [message #25170 is a reply to message #25147]

Sun, 29 May 2005 22:43

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

What theme are you using with your forum, is it based on greek?

FUDforum Core Developer

Report message to a moderator

Re: Weird repsesentation of greek language [message #25180 is a reply to message #25147]

Mon, 30 May 2005 09:28

foris

Messages: 3
Registered: May 2005

Karma: 0

Junior Member

I'm using the default english theme, which is propably the theme I'm going to use when I finally deploy EGW.

All the greek strings, are being saved in the database in unicode representation (for example & # 9 8 3 ; - six characters per string character!). The same happens to the files that hold the posts.

So far I found out that the category name is trimmed, because the name field at the phpgw_cat table is VARCHAR(50). So I got on the screen 8 characters (8X6=48) and two spaces!

The real question now is: Since everything greek is being stored in the same way, both in the database and the msg files, why do I get hashes and numbers instead of characters where the forum name is to be presented?

Note: All the tables in the database use charset latin1 and collation method latin1_swedish_ci.

Report message to a moderator

Re: Weird repsesentation of greek language [message #25197 is a reply to message #25180]

Tue, 31 May 2005 03:01

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

In the theme settings on theme manager change the locale & charset to that used for greek language. That should fix the problem.

FUDforum Core Developer

Report message to a moderator

Re: Weird repsesentation of greek language [message #25219 is a reply to message #25147]

Tue, 31 May 2005 21:27

foris

Messages: 3
Registered: May 2005

Karma: 0

Junior Member

Well I tried creating a new theme for greek by creating a new directory under i18n and using ISO-8859-7 as charset. That didn't solve the problem so I tried to check out the source code a bit.

After having experimented a bit, I found out that the problem is caused by the htmlspecialchars() conversion the script does to the forum name. While the category name and all the descriptions are being shown plain without conversion, for the forum name, the unicode string (& # 4 3 5 ; ) is being converted from text to html so the browser presents the unicode string literaly!

If I finally get the chance to deploy EGW and fudforum, I will hack the source code a little to achieve the goal!

Anyway, thanks for the thoughts and for spending time on this! And most of all, thanks for a great open source forum!

Smile

Report message to a moderator

Re: Weird repsesentation of greek language [message #25230 is a reply to message #25219]

Wed, 01 June 2005 00:08

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Interesting, after changing to ISO-8859-7 when you type in Greek does it still appear as unicode character sequences?

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Timing Out When Replying
Next Topic:	File attachment not able to upload above 500KB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 23:03:37 GMT 2024

Total time taken to generate the page: 0.14333 seconds