topic Search engine + non-ascii characters in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/search-engine-non-ascii-characters/m-p/217356#M170486 <HTML><HEAD></HEAD><BODY><SPAN>Hello everyone</SPAN><BR /><BR /><SPAN>I am having few issues. Most of them I got rid off but there is still one or two left. I really appreciate any help.</SPAN><BR /><BR /><SPAN>I am using UTF-8 character coding in file names (Czech language). I did manage to set up MySQL database to UTF8 </SPAN><BR /><BR /><SPAN>(mysql.ini)</SPAN><BR /><SPAN>&nbsp;&nbsp; default-character-set = utf8</SPAN><BR /><SPAN>&nbsp;&nbsp; skip-character-set-client-handshake</SPAN><BR /><BR /><SPAN>and all the tables within the database have set and been converted to COLLATION utf8_general_ci </SPAN><BR /><BR /><SPAN>and I set alfresco to comunicate in UTF-8 as well.</SPAN><BR /><BR /><SPAN>(custom-repository.properties)</SPAN><BR /><SPAN>&nbsp;&nbsp; db.url=jdbc:mysql://localhost/bitnami_alfresco?useUnicode=true&amp;characterEncoding=utf-8</SPAN><BR /><BR /><SPAN>EVERYTHING WORKS WELL SO FAR</SPAN><BR /><BR /><SPAN>however when I am using search engine for file names only it doesn't work on 100%</SPAN><BR /><BR /><SPAN>it has no problem to find a word like "vstřikovna" with chars ěščřž&nbsp; however a word "balení" with chars like áíéý it just refuse. </SPAN><BR /><SPAN>Alfresco gives me a message no files found and that's it.</SPAN><BR /><BR /><SPAN>I have also problem with importing data in zip file. Files with non-ascii character are uplouded through http or FTP without problem but when they are compressed in zip file it writes insteand of ěščří some ????? or other funny things.</SPAN><BR /><BR /><SPAN>Can somebody help me? Or at least point me the right direction? Thank you in advance, cheers</SPAN></BODY></HTML> Tue, 29 Jun 2010 08:21:18 GMT cisco 2010-06-29T08:21:18Z Search engine + non-ascii characters https://connect.hyland.com/t5/alfresco-archive/search-engine-non-ascii-characters/m-p/217356#M170486 Hello everyoneI am having few issues. Most of them I got rid off but there is still one or two left. I really appreciate any help.I am using UTF-8 character coding in file names (Czech language). I did manage to set up MySQL database to UTF8 (mysql.ini)&nbsp;&nbsp; default-character-set = utf8&nbsp;&nbsp; skip-characte Tue, 29 Jun 2010 08:21:18 GMT https://connect.hyland.com/t5/alfresco-archive/search-engine-non-ascii-characters/m-p/217356#M170486 cisco 2010-06-29T08:21:18Z Re: Search engine + non-ascii characters https://connect.hyland.com/t5/alfresco-archive/search-engine-non-ascii-characters/m-p/217357#M170487 <HTML><HEAD></HEAD><BODY><SPAN>Alright seems I have found a way around,</SPAN><BR /><BR /><SPAN>I have two translations installed ENGLISH / CZECH</SPAN><BR /><BR /><SPAN>when I log in using english translation search refuse to find the files with non-ascii characters HOWEVER if I use czech translation it suddenly works fine!</SPAN><BR /><BR /><SPAN>Cheers</SPAN></BODY></HTML> Tue, 29 Jun 2010 10:47:25 GMT https://connect.hyland.com/t5/alfresco-archive/search-engine-non-ascii-characters/m-p/217357#M170487 cisco 2010-06-29T10:47:25Z Re: Search engine + non-ascii characters https://connect.hyland.com/t5/alfresco-archive/search-engine-non-ascii-characters/m-p/217358#M170488 <HTML><HEAD></HEAD><BODY><SPAN>Yes it is correct behaviour.</SPAN><BR /><BR /><SPAN>From </SPAN><A href="http://wiki.alfresco.com/wiki/Search" rel="nofollow noopener noreferrer">Search wiki page</A><SPAN>:</SPAN><BR /><BLOCKQUOTE class="jive-quote">All multilingual fields are indexed and tokenized according to the locale. The tokens are prefixed in the index with locale information.<BR /><BR />When searching, the locale(s) to use can be specified on the SearchParameters. If they are not specified, the locale defaults to the user's login locale (the locale selected when the user logged in).</BLOCKQUOTE><BR /><SPAN>I must ask - have you found any better translation then the one at </SPAN><A href="http://forge.alfresco.com/forum/forum.php?thread_id=464&amp;forum_id=352" rel="nofollow noopener noreferrer">Alfresco forge</A><SPAN>?</SPAN></BODY></HTML> Tue, 27 Jul 2010 14:11:15 GMT https://connect.hyland.com/t5/alfresco-archive/search-engine-non-ascii-characters/m-p/217358#M170488 trakhan 2010-07-27T14:11:15Z