UTF-8 Character encoding issue

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2008 05:30 AM
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?
I appreciate any help to resolve the issue.
Thank you very much
Sriram Balasubramanian
- Labels:
-
Archive
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2009 08:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2009 08:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2009 09:32 AM
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?
Thanks.
JR
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2009 02:35 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2010 09:47 PM
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:
CHANGE: index.recovery.mode=AUTO -> index.recovery.mode=FULL
CHANGE: db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=true&characterEncoding=utf-8
5. Restart Alfresco
6. Remember to change index.recover.mode back to AUTO.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2010 06:00 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2010 07:46 AM
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.
When I tried second path as "http://localhost:8080/share/page/site/epdk/documentlibrary#filter=path|%2Fklas%F6r" I access to the expected page.
Thank you very much.
note: I use Community Edition 3.3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2017 03:04 AM
Sorunu çözebildiniz mi? Aynı sorunla karşılaştım, çözdüyseniz bana yardımcı olabilir misiniz?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2010 08:13 AM
Thanks,
Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2012 01:21 AM
i want to make the special characters like ?, \, *, /,",: allownle for the name of the content in create content wizard.
Thanks
