Explorer localization

[trakhan]

Hi everyone. I installed Czech localization into Alfresco by copying *.properties files from zip file, into shared/classes/messages and modified file shared/classes/extensions/web-client-config-custom.xml to display both English and Czech language. It works like a charm, without any problems.

Problems start when I try to create content/space and put some localized characters into space (file) name. These characters get garbled - apparently alfresco is not prepared for the localized texts (explorer localization is just fine).

So where could be problem?

PS. I test alfresco on CentOS system, installed just to this purpose and I configured locale to cs_CZ.utf8 during the instalation od CentOS

[trakhan]

I created some screenshots of the problem I'm having. they can be found here: http://disk.jabbim.cz/trakhan@jabber.cz/alf_problem/

Adittionally I think, that this problem is specific to linux (or CentOS 4), since i have another image of same way configured Alfresco on Windows 7, where everything works just fine.

[trakhan]

I tried to reinstall alfresco in the system, but as expected the reinstallation have no effect on problems with garbled characters. So I looked into mysql database and found out, that the text is garbled in database;

Text from mysqldump:

INSERT INTO `alf_node_properties` VALUES (549,6,6,0,0,0,0,'?š??žýáíé',NULL,27,-1,1)‍

Text in mysql get by mysql console client:

select string_value from alf_node_properties where node_id = 549 and qname_id = 27;
+————–+
| string_value |
+————–+
| ?�??�����    |
+————–+
1 row in set (0.00 sec)‍‍‍‍‍‍‍

SHOW CREATE TABLE  alf_node_properites;

CREATE TABLE `alf_node_properties` (
  `node_id` bigint(20) NOT NULL default '0',
  `actual_type_n` int(11) NOT NULL default '0',
  `persisted_type_n` int(11) NOT NULL default '0',
  `boolean_value` tinyint(1) default NULL,
  `long_value` bigint(20) default NULL,
  `float_value` float default NULL,
  `double_value` double default NULL,
  `string_value` text,
  `serializable_value` blob,
  `qname_id` bigint(20) NOT NULL default '0',
  `list_index` int(11) NOT NULL default '0',
  `locale_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`node_id`,`qname_id`,`list_index`,`locale_id`),
  KEY `fk_alf_nprop_n` (`node_id`),
  KEY `fk_alf_nprop_qn` (`qname_id`),
  KEY `fk_alf_nprop_loc` (`locale_id`),
  CONSTRAINT `fk_alf_nprop_loc` FOREIGN KEY (`locale_id`) REFERENCES `alf_locale` (`id`),
  CONSTRAINT `fk_alf_nprop_n` FOREIGN KEY (`node_id`) REFERENCES `alf_node` (`id`),
  CONSTRAINT `fk_alf_nprop_qn` FOREIGN KEY (`qname_id`) REFERENCES `alf_qname` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It seems to me, that alfresco doesn't use utf or convert characters from/to utf when working with database.

Any  idea?

[mikeh]

Make sure MySQL is set to use UTF-8.

Thanks,
Mike

[trakhan]

Ok - I figured out the solution. The problem was, that I had character_set_system set correctly to utf8, which I already checked. What I did not check was other mysql settings. So show variables like 'character_set%' showed me the problem:

show variables like 'character_set%'
    -> ;
+————————–+—————————-+
| Variable_name            | Value                      |
+————————–+—————————-+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+————————–+—————————-+
7 rows in set (0.00 sec)‍‍‍‍‍‍‍‍‍‍‍‍‍‍

So I added following to my.cnf and everything works fine:

character_set_client=utf8
character_set_server=utf8
‍‍‍

[coufal]

Hi
i am looking for czech language pack… could you help me, pls?
Thx

coufal@silon.eu