nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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