<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoPlainText><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Hi Mario<o:p></o:p></span></p><p class=MsoPlainText><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoPlainText><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>We had the same problem in 3.2. I think the solution was to implement a custom orderkey on the author's id field which our author view is based on (in our repository the id field contains family_name + given_name). The custom order key uses <a href="http://search.cpan.org/perldoc/Text::Unidecode">Text::Unidecode</a> to strip the diacritics from letters for sorting and grouping purposes. See example below. <o:p></o:p></span></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>use Text::Unidecode;<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>sub make_id_orderkey_single<o:p></o:p></p><p class=MsoPlainText>{<o:p></o:p></p><p class=MsoPlainText> my ( $self, $value, $session, $langid, $dataset ) = @_;<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText> # convert to upper case ASCII<o:p></o:p></p><p class=MsoPlainText> my $orderkey = uc( unidecode( $value ) );<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText> # ignore apostrophes and hyphens<o:p></o:p></p><p class=MsoPlainText> $orderkey =~ s/['-]//g;<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText> return $orderkey<o:p></o:p></p><p class=MsoPlainText>}<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Kind regards<o:p></o:p></span></p><p class=MsoPlainText><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Mark<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b><span style='color:#C50B45'>Mark Gregson</span></b><b> </b>| Applications and Development Team Leader<br><span style='color:gray'>Library eServices | Queensland University of Technology<br>Level 3 | R Block | Kelvin Grove Campus | GPO Box 2434 | Brisbane 4001<br>Phone: +61 7 3138 3782 | Web:</span><span style='color:#A3A3A3'> </span><u><span style='color:#0000FD'><a href="http://www.qut.edu.au/">http://eprints.qut.edu.au/</a><br></span></u><span style='color:#0080FF'>ABN: 83 791 724 622<br>CRICOS No: 00213J<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p><p class=MsoPlainText>-----Original Message-----<o:p></o:p></p><p class=MsoPlainText>From: <a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a> [<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">mailto:eprints-tech-bounces@ecs.soton.ac.uk</a>] On Behalf Of Mario Beaudoin<o:p></o:p></p><p class=MsoPlainText>Sent: Tuesday, 18 December 2012 6:13 AM<o:p></o:p></p><p class=MsoPlainText>To: <a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><o:p></o:p></p><p class=MsoPlainText>Subject: [EP-tech] Sort result by author, by title<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Hello<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>I use eprints 3.3.7 in dev server and 3.2.9 in production and i notice then both when we use a french accent in the authors name the sort do not use utf8_general _ci to sort correctly the é goes after the z letter (like we use utf8_bin) (in browse by author and in sort by author or title after search) i look in the sql table eprint_ordervalue_fr creators_name the collate is utf8_general_ci that sort perfecly (phpmyadmin) i already have this bug in older version of eprints and to correct the bug i modify utf8_bin to utf8_general_ci who sort everyting correcly after this change but now the table collation is correct so i take a look on view.pl but nothing there to sort i take a look on view.pm who seem to sort the browse by author but i am not sure what to modify exactly<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Thank for your help<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>look here the Bé... is at the end of B letter <a href="http://espace.etsmtl.ca/view/creators/index.B.html">http://espace.etsmtl.ca/view/creators/index.B.html</a><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>or this one whewe É is a new letter after the A <a href="http://espace2.etsmtl.ca/view/master_director/index.A-=C9.html">http://espace2.etsmtl.ca/view/master_director/index.A-=C9.html</a><o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>Mario<o:p></o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText><o:p> </o:p></p><p class=MsoPlainText>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><o:p></o:p></p><p class=MsoPlainText>*** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><o:p></o:p></p><p class=MsoPlainText>*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><o:p></o:p></p></div></body></html>