topic Re: UTF-8 for Filename and Spacename ? in Alfresco Archive

UTF-8 for Filename and Spacename ?

vinaxwater — Fri, 13 Feb 2009 08:20:39 GMT

I use package stable of alfresco3.0. I set MYSQL with utf8_general_ci for DB and all tables have field "Collation", i set db.url=jdbc:mysql:///${db.name}?useUnicode=true&characterEncoding=utf-8. But it's not effect, i only have ??? for fileName and Space name with UTF-8. Help me!Thanks.

Re: UTF-8 for Filename and Spacename ?

kayan — Fri, 13 Feb 2009 09:40:03 GMT

Hi,

You can try following setting :

Change MYSQL database :

Character set: utf8 – UTF-8 Unicode
Collation :utf8_bin

Entries in custom-repository.properties

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost:3306/alfresco?useUnicode=true&characterEncoding=utf-8

Hope it helps you.

Thanks
Kayan

Re: UTF-8 for Filename and Spacename ?

vinaxwater — Mon, 16 Feb 2009 04:20:21 GMT

Thanks for Read and Reply. I check MYSQL yet support utf8. I share my solution:

Check and Set UTF-8 for MYSQL Server:

Shell>mysql
mysql>status;

You will see:
[img]http://chiase.anhso.net/as/09/02/16/step875976.gif[/img]

In ficture with the line red. Note 2 line top MYSQL supported utf8. If it's not character utf8 please edit file: /etc/my.cnf
added:

default-character-set=utf8‍

after check again You will have the same top ficture. Then restart MYSQL server.

Check and Set UTF-8 for MYSQL Client:

This for set 2 line bottom in the ficture to utf8:

Shell>mysql
mysql>status;
mysql>set names utf8;
mysql>status;

This is last ficture:
[img]http://chiase.anhso.net/as/09/02/16/step542643.gif[/img]

Regards.

Re: UTF-8 for Filename and Spacename ?

vinaxwater — Mon, 16 Feb 2009 04:46:09 GMT

It's error utf8 with Flash in Share in Alfresco. Please help me.

Regards.