Greek titles problem

[aeon]

Greetings everyone,

I've installed alfresco-tomcat 1.20 final. I'm using the Greek language pack and all everything seems to work correctly apart from the titles in Content Items and Spaces. They always appear in the form e.g.  ?????.txt  or ?????.html no matter what I enter (note: if I click on them, the corresponding text or html that they refer to appears properly in Greek).

I realise that this is either an encoding problem or the information that concerns the titles is not stored properly into the database.

I've created the alfresco database in UTF-8 (trying as collation utf8-general-ci or even utf8-unicode-ci) in order to get Greek titles appearing properly, but nothing different happened. I've even set the encoding to the specific table & field where the erroneous titles are contained to the ones mentioned above and still I get the same result.

However when I do the following:

a) edit the titles straight from the db (using MySQL Query Browser) and enter Greek text
b) stop and restart alfresco,

then, and ONLY then, the titles appear correctly in Greek.

Is this a bug (wrong parsing of the titles to the db) or am I doing something wrong?

A prompt reply will be greatly appreciated!

Thank you in advance,


P.S: This was accidentally posted to Remository Services. Please delete the initial post!

[kevinr]

Hello,

We have tested 1.2 with various character sets including Korean, Japanese and Chinese. Assuming the database is UTF-8 (as you say it is) then I haven't seen the problems you mention. I'll take a look with the Greek language pack specifically and get back to you.

Thanks,

Kevin

[kevinr]

Hi,

OK i've done some testing with the Greek language pack. Everything looks fine to me (not that i'm fluent ) I created a Space and a Content File with greek names, both persisted to the DB correctly and are displayed in the web-client correctly also:
http://wiki.alfresco.com/w/images/8/8a/GreekUTF8.png

My database is MySQL 4.1.12 and another machine has MySQL 5.0.18 and is also ok.

The database schema character set is "utf8" using InnoDB tables.

Thanks,

Kevin

[aeon]

Thank you for your reply kenvir.

The reason why I get question marks instead of proper characters still eludes me. It appears I have done everything the same way with you, but the problem maintains.

I'll search a bit more for a solution and I'll keep you posted in case I discover anything.

[steve]

Hello,

Do you have the following in your 'my.ini' (windows) or 'my.cnf' (linux)?

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

[mysqld]
…
default-character-set=utf8
…
‍‍‍‍‍‍‍‍‍‍‍

You can set your tables to use UTF-8 but the JDBC connector needs the above information to know that it should be using UTF-8 to transfer info from the Alfresco application to the DB and back again.

Hope this helps,

Steve

[aeon]

Thank you so much Steve,

It actually did work!

It was very simple after all