<div>So am I basically hearing that the sorting is not wrong. In the en_US locale "X", "X 2", and "X 3" are correctly sorted as "X 3", "X 2", "X", and this is not possible to change (easily or correctly)?
</div>
<div> </div>
<div>I just want to know if it's worth my time to investigate the source of MythVideo's use of locale collation and such to try and create some sort of additional plugin or option patch that would sort differently even in the current locale?
</div>
<div> </div>
<div>I'm sure there's a way for me to sort differently (say by file name) and then rename all my files or just live with it if this is simply not something that is changable or desired by anyone but me.</div>
<div> </div>
<div>Thanks,</div>
<div>Brion<br><br> </div>
<div><span class="gmail_quote">On 12/13/07, <b class="gmail_sendername">Michael T. Dean</b> <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On 12/13/2007 08:05 AM, Brion Swanson wrote:<br>> This suggests that my sorting problem really does lie within the Myth
<br>> code and not my locale or mysql because clearly Myth is re-ordering the<br>> results from mysql in order to ignore articles and such,<br><br>Right. As Anduin mentioned in a previous post, MythVideo re-sorts the
<br>list independent and does /not/ use a MySQL sort.<br><br>> but in doing so<br>> I'm wondering if it's unintentionally reversing the order of like-named<br>> movies (trilogies)?<br>><br><br>Not exactly. Myth is re-sorting the list, but using a different
<br>approach which uses a locale-specific collation order that's not exactly<br>what you expect. Myth doesn't pay any attention to the order in which<br>results are returned by MySQL.<br><br>To find out why, feel free to move to another country with a different
<br>locale (including some non-ASCII characters in the alphabet), learn to<br>speak/read/collate in the language, and then repeat your DB tests.<br>(Basically, MySQL could only properly sort the titles (in a<br>properly-configured MythTV database) if you're using US English or
<br>similar--and even then, as you've discovered, doesn't ignore articles.)<br><br>Mike<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org
</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div><br>