cancel
Showing results for 
Search instead for 
Did you mean: 

Default installation doesn't support Russian

maximshiryaev
Champ in-the-making
Champ in-the-making
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)
4 REPLIES 4

steve
Champ in-the-making
Champ in-the-making
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
Champ in-the-making
Champ in-the-making
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
Champ in-the-making
Champ in-the-making
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
Champ in-the-making
Champ in-the-making
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.