topic Re: Greek titles problem in Alfresco Archive

Greek titles problem

aeon — Tue, 28 Mar 2006 06:43:15 GMT

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

Re: Greek titles problem

kevinr — Tue, 28 Mar 2006 11:36:58 GMT

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

Re: Greek titles problem

kevinr — Tue, 28 Mar 2006 16:45:44 GMT

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

Re: Greek titles problem

aeon — Mon, 03 Apr 2006 08:58:17 GMT

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.

Re: Greek titles problem

steve — Mon, 03 Apr 2006 15:48:21 GMT

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

Re: Greek titles problem

aeon — Wed, 05 Apr 2006 08:49:38 GMT

Thank you so much Steve,

It actually did work!

It was very simple after all