topic Re: Can't upload files with accented characters in Alfresco Archive

Can't upload files with accented characters

guilherme_souza — Mon, 07 May 2012 20:08:28 GMT

Hi, i've created a aspect to type the file, and this value may have accented characters. I've putted a list in the upload form to standardize the types, but they appear like the image below:[img]http://img842.imageshack.us/img842/3281/accented.png[/img]The word that should appear at the selected ite

Re: Can't upload files with accented characters

mitpatoliya — Tue, 08 May 2012 09:49:29 GMT

Have you configured your database to support the UTF-8 characters?
You need to do that .
Check out this post
https://forums.alfresco.com/en/viewtopic.php?f=45&t=44504&p=130815#p130815

Re: Can't upload files with accented characters

guilherme_souza — Tue, 08 May 2012 13:50:54 GMT

I thought about changing the encoding of the database, but when I went to change, I've seen that the encoding was already in utf-8:

[img]http://img15.imageshack.us/img15/9226/encoding.png[/img]

so, what is happening with the list objects ?

Re: Can't upload files with accented characters

jordiv — Thu, 10 May 2012 07:46:00 GMT

You could also check that the XML file where you defined your aspect is encoded in UTF-8 as well.

Cheers,
Jordi

Re: Can't upload files with accented characters

jpfi — Thu, 10 May 2012 09:11:44 GMT

Hi,
and your java process should be started with UTF-8 encoding (-Dfile.encoding=utf-8)
cheers, jan

Re: Can't upload files with accented characters

guilherme_souza — Thu, 10 May 2012 15:05:35 GMT

I've already defined the encode method in the XML file, but i don't know how to define this in the java process. I would be very grateful if someone could explain to me how I should proceed to define this in the java process too.

Re: Can't upload files with accented characters

afaust — Thu, 10 May 2012 17:24:08 GMT

In a properly set up server you should not need to specify the file encoding, but to be safe you should append the parameter Jan mentioned to the JVM start parameters (JAVA_OPTS for Tomcat) e.g.


export JAVA_OPTS = %JAVA_OPTS% -Dfile.encoding=UTF-8
[code]

Also, your database seems to be set to a Brazilian-Portugese character set / code page. So even if your database speaks UTF-8 on the connection layer, if the persistence layer has troubles with some characters you will never get a decent result.
It is 2012 - everything should have been UTF-8 by default by now. That means
[*] database character set
[*] database server connection encoding
[*] database client connection encoding (e.g. for MySQL, there is an additional paramter in the JDBC connection string)
[*] file system encoding (or, if that is lacking, the Java file.encoding)
[*] application server request / response content as well as URI encoding‍‍‍‍‍‍‍‍‍‍‍