Hello, I am very new to Alfresco and have some basic questions related to UTF-8 character set.
I am trying to create a folder/discussion topic using "Tamil" language. It is showing ????" marks after creation of the folder.
Following things where done by me: ————————————————- Installed community version of alfresco. Installed mysql with UTF-8 encoding. I checked that tomcat server.xml file contains URIencoding as "UTF-8". I created language files under: tomcat/webapps/alfresco/WEB-INF/classes/alfresco/messages directory specific to Tamil. I made sure that "encoding_utf8=UTF-8" is present in /webclient_ta_TA.properties.
I have a plugin which allows me to enter "Tamil" characters using firefox browser. I used that plugin to enter "Tamil" text while creating the folder and discussion topic. But after entering the text, it stores the data and display back as "????" marks. Search functionality is working fine: If I do search, it is retrieving correctly. but it only displays "????" marks.
How can I configure Alfresco to allow for "Tamil" characters?
Deleting completely database and installing it again with default-character-set=utf8 im my.ini helped.
Is anyone actually using Alfresco for production use? Seems I see a lot of responses like the above which to me would elude to having no data that they care about. Or is there a way to recreate the schema in it's entirety and import the data back in?
Or is there a way to recreate the schema in it's entirety and import the data back in? JR
I think this is a question for MySQL forum :wink: I think that of course you can save your data and import it back. But anyway you should re-install database. I tried all things, but only this really helped.
Here is step-by-step instructions on how to recover a production environment with this issue so you don't lose any data:
1. Stop Alfresco 2. Run the PHP Script below to convert the database into UTF-8:
<?php $db = mysql_connect('localhost','root','root_password'); if(!$db) echo "Cannot connect to the database - incorrect details"; mysql_select_db('alfresco'); mysql_query('ALTER DATABASE CHARACTER SET utf8'); $result=mysql_query('show tables'); while($tables = mysql_fetch_array($result)) { foreach ($tables as $key => $value) { mysql_query("ALTER TABLE $value CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci"); }} echo "The collation of your database has been successfully changed!"; ?>
3. Delete the lucene-indexes directory under the Alfresco data directory 4. Edit alfresco-global.properties in tomcat/shared/classes directory for the following:
My database and tables where already set to utf-8. All I needed to do is make the one change to alfresco-global.properties file, e.i.: db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=true&characterEncoding=utf-8 and restart alfresco.
I have a page redirection problem caused by character encoding. I can give Turkish names to my folders and view them without any problem. But the problematic scenario is: 1- I create a folder named "klasör" (folder in turkish) and there is no displaying problems. 2- I view the details of the "klasör" 3- In folder details page I try to go back to documentlist page via breadcrumb (which writes "Location: Documents Documents > klasör", I click klasör link). This directs me to the page "http://localhost:8080/share/page/site/epdk/documentlibrary?path=klas%F6r", from here I automatically redirected to another page "http://localhost:8080/share/page/site/epdk/documentlibrary#filter=path|%2Fklasör" and get "Path not found: 'klasör'" error.
