[SOLVED] - alpha1: hate arabic

[Fuga]

while iam working for translate the new version to arabic i surprised 
why 1.1 alpha1 hate arabic ?
because you used utf-8 for encoding and arabic character work only with windows-1256

this means 1.1 alpha1 can only write in english fonts in the content , sections , category , menus , modules and mambot

so when you write arabic your character will changed to ?? like this picture in the attachment

[Jinx]

Oke first of all this is a DB issue not simple an UTF-8/windows-1256 issue. Can u tell me what DB version u are using and if u made any changes to the install script of Joomla.

[Fuga]

mmm so why joomla 1.0.x works fine ?

anyway this is my info :

Apache Web Server Version 1.3.33

PHP Script Language Version 4.3.10

MySQL Database Version 4.1.8

Zend Optimizer Version 2.5.7

phpMyAdmin Database Manager Version 2.6.1-rc2
========

i will downgrade my mysql to be sure this problem is from the db

[Jinx]

As I thought, this problem has already been identified and will be fixed in alpha2. In the mean time here is a fix :

In the file includes/database.php on line 92/93 remove the following

//Set charactersets (needed for MySQL 4.1.2+)
mysql_query("SET CHARACTER SET utf8",$this->_resource);
mysql_query("SET NAMES 'utf8'", $this->_resource);

This should fix your problem.

[Fuga]

ooh its to late i have downgraded my mysql   so i can not try your fix to be sure
after i downgrade my mysql works fine with arabic 

where i can submit the bugs for language ?

[Jinx]

U can post them on the 1.1 bugtracker on the forge.

[davidgal]

while iam working for translate the new version to arabic i surprised 
why 1.1 alpha1 hate arabic ?
because you used utf-8 for encoding and arabic character work only with windows-1256

this means 1.1 alpha1 can only write in english fonts in the content , sections , category , menus , modules and mambot

so when you write arabic your character will changed to ?? like this picture in the attachment

Hi,

The problem you encountered is not unique to Arabic. I too, ran into the same problems. However, utf-8 does most definitely work with Arabic and all other languages.

The whole idea is to get away from language specific charsets such as windows-1256 and all others and live with only one charset for all. Just think of all the settings one needs to get Arabic working correctly - php needs to know, the browser needs to know, the database needs to know, the webserver needs to know. The great idea behind utf8 and unicode in general is that everthing will have one setting and be ready for all languages.

Some background on utf-8 http://www.cl.cam.ac.uk/~mgk25/unicode.html#utf-8

True, the road to the rose garden has some bumps and Joomla is now a new traveller on this road.

Your inputs on Arabic specific issues, as the new version develops, will be most welcome.