Default installation doesn't support Russian

[maximshiryaev]

Why doesn't default installation support international characters?

As I understand the problem is in MySQL configuration which is set up for latin-1 character set. If it were configured for UTF-8 it would work without any additional efforts, would it?

Maxim Shiryaev.

PS. The problem with Russian is that all Russian workspace names or descriptions are displayed as "???????".
(Version 1.2, Windows, Tomcat)

[steve]

Hello,

You do indeed need to set MySQL to be running using UTF-8.

Alfresco itself is fully internationalised, so once MySQL is running using UTF-8 you should see your Russian characters.

Hope this helps,

Steve

[maximshiryaev]

Thank you, Steve.

I'm not an expert in MySQL. Could you, please, point me to some info about MySQL cofiguration parameters and where to set them in Alfresco?

But actually I'll try to run Alfresco with Firebird 2.0 first because all our company's information systems are running on Firebird. I've managed to run it but it has almost the same problem - Russian characters raise JDBC exception instead of "?????". The problem with Firebird is that it requires additional connection parameters (along with DB URL, user name and password), namely encoding which must be set to UTF-8. But I don'tknow where to set it in Alfresco. I suppose it should be set somewhere in Hibernate setting but cannot find where…

Maxim.

[steve]

Hello,

You should have a 'my.ini' (windows) or 'my.cnf' (linux) file.
In there, to configure UTF-8 you should make sure that your file includes the following:

[client]
…
default-character-set=utf8
…

[mysqld]
…
default-character-set=utf8
default-storage-engine=INNODB
…
‍‍‍‍‍‍‍‍‍‍‍‍

As for configuring JDBC connection settings, these are found in 'repository.properties'. You should override this file by following the instructions found here: http://wiki.alfresco.com/wiki/Repository_Configuration

Hope this helps,

Steve

[maximshiryaev]

MySQL is successfully reset to UTF8.

There were two errors during regeneration of db.
In db_remove.bat the line

"C:\Program Files\alfresco-1.2/mysql\bin\mysql" -u root -p < C:\Program Files\alfresco-1.2\bin\db_remove.sql

actually must be (double quotes)

"C:\Program Files\alfresco-1.2/mysql\bin\mysql" -u root -p < "C:\Program Files\alfresco-1.2\bin\db_remove.sql"

The same problem is in db_setup.bat.


As for Firebird, it's also solved. Two modifications are required:

1. In hibernate-cfg.properties:
hibernate.dialect=org.hibernate.dialect.FirebirdDialect

2. In custom-repositary.properties:
db.url=jdbc:firebirdsql:native:localhost:your_database_path/you_database_file.FDB?lc_ctype=UNICODE_FSS
The latter assumes that the database is created with UNICODE_FSS or UTF8 charset.

Maxim.