Re: [Fez-users] sorting with diacritical characters

[Luis Z. <lz...@pa...>]

Hi Kai,
I've done the modifications, actually  add  in my.cnf  , but I  will 
wait until reindex  the objects into fedora.
So , along this month I'll find out if the problem is solved.
Thanks for your kind cooperation.
Luis
Kai Jauslin escribió:
> Hi Luis
> a) make sure the MySQL table fez_record_search_key_authors has the 
> collation "utf8_general_ci" or "utf8_unicode_ci" (details on these 
> collations can be found in the mysql manual). Depending on your MySQL 
> version, there might also be other reasonable collations available.
> b) make sure that PHP really connects to MySQL using utf8. At ETH Zurich 
> (e-collection.ethbib.ethz.ch), we are using the following options in the 
> my.ini (to force UTF-8 for all connections)
>
> default-character-set=utf8
> collation_server=utf8_unicode_ci
> character_set_server=utf8
> skip-character-set-client-handshake
>
> c) if you did not have b) then you probably have non-utf8 data in the 
> author table and the sorting is done wrong (but display can be correct). 
> In this case, you should do a complete reindex of all Fedora documents.
> d) there are probably more utf-8 issues we have already fixed, but we 
> are behind in schedule for porting them back to the Fez development trunk
>
> Cheers, Kai
>
> Luis Zorita schrieb:
>   
>> Hi all:
>> I'm having problems when browsing authors. The problem comes from 
>> sorting the list of authors. For instance : cámara is placed below 
>> cavallaro and should be above.
>> Is there a way to sort consdering the diacritical characters?
>> Thanks in advance
>> Luis Zorita
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Microsoft
>> Defy all challenges. Microsoft(R) Visual Studio 2008.
>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>> _______________________________________________
>> Fez-users mailing list
>> Fez...@li...
>> https://lists.sourceforge.net/lists/listinfo/fez-users
>>   
>>     
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Fez-users mailing list
> Fez...@li...
> https://lists.sourceforge.net/lists/listinfo/fez-users
>
>