<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Case, accent and punctuation insensitive sorting </title>
	<link>http://www.trirand.com/blog/?page_id=393/help/case-accent-and-punctuation-insensitive-sorting</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/case-accent-and-punctuation-insensitive-sorting/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>McCulloch on Case, accent and punctuation insensitive sorting </title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/case-accent-and-punctuation-insensitive-sorting#p22745</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/case-accent-and-punctuation-insensitive-sorting#p22745</guid>
        	        	<description><![CDATA[<p>Here is what I ended up doing:</p>
</p>
<p>$("#dataGrid").jqGrid({<br />&#160; &#160; ...<br />&#160; &#160; colModel: [</p>
<p>&#160;&#160; &#160; &#160;&#160; { name: &#39;subject&#39;, index: &#39;subject&#39;, sortable: true, classes: &#39;ui-ellipsis&#39;, width: columnWidths.subject,<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; sorttype: function (cell) { return sortable(cell); } }<br />&#160; &#160; &#160; &#160; ],<br />&#160;&#160;&#160; ... &#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160;&#160;</p>
<p>});</p>
<p>...</p>
<p>function makeSortable(s)<br />{<br />&#160;&#160; &#160;var r = s.toLowerCase();<br />&#160;&#160; &#160;var diacritics = [<br />&#160;&#160; &#160;&#160;&#160; &#160;[/[\340-\346]/g, &#39;a&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;[/[\350-\353]/g, &#39;e&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;[/[\354-\357]/g, &#39;i&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;[/[\362-\370]/g, &#39;o&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;[/[\371-\374]/g, &#39;u&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;[/[\361]/g, &#39;n&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;[/[\347]/g, &#39;c&#39;]<br />&#160;&#160; &#160;];</p>
<p>&#160;&#160; &#160;for (var i = 0; i &#60; diacritics.length; i++)<br />&#160;&#160; &#160;{<br />&#160;&#160; &#160;&#160;&#160; &#160;r = r.replace(diacritics[i][0], diacritics[i][1]);<br />&#160;&#160; &#160;}<br />&#160;&#160; &#160;return r;<br />}</p></p>
]]></description>
        	        	<pubDate>Mon, 11 Apr 2011 23:25:38 +0300</pubDate>
        </item>
        <item>
        	<title>McCulloch on Case, accent and punctuation insensitive sorting </title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/case-accent-and-punctuation-insensitive-sorting#p22741</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/case-accent-and-punctuation-insensitive-sorting#p22741</guid>
        	        	<description><![CDATA[<div id="post22740">
<p>Currently the sorttype property of a column defines the type of the column for appropriate sorting.</p>
<p>Possible values include int/integer &#8211; for sorting integer ;  float/number/currency &#8211; for sorting decimal numbers ; date &#8211; for sorting  date and text &#8211; for text sorting.</p>
<p>I have a need for case, punctuation and accent insensitive text sorting. Does anyone know how to use a custom sorting fuction to achieve this?</p>
<p>For example, currently jqGrid sorts a column in this order:</p>
<ol>
<li>&#8230;</li>
<li>Cross-border reorganization</li>
<li>Crystallization of&#8230;</li>
<li>Cr&#233;dit d&#39;imp&#244;t &#8230;</li>
<li>&#8230;</li>
<li>Draft Guidance on &#8230;</li>
<li>Dubai Investment</li>
<li>D&#233;cisions r&#233;centes</li>
<li>&#8230;</li>
<li>Lutte contre les planifications fiscale</li>
<li>L&#8217;Institut des Cadres Fiscaliste: &#8230;</li>
<li>Majoration fiscale &#8230;</li>
<li>&#8230;</li>
<li>World Tour &#8230;</li>
<li>&#201;cole de hautes &#8230;</li>
<li>&#8230;</li>
</ol>
<p>The requirement is to have a sortable column in this order:</p>
<ol>
<li>&#8230;</li>
<li>Cr&#233;dit d&#39;imp&#244;t &#8230;</li>
<li>&#8230;</li>
<li>Cross-border reorganization</li>
<li>Crystallization of&#8230;</li>
<li>&#8230;</li>
<li>D&#233;cisions r&#233;centes</li>
<li>&#8230;</li>
<li>Draft Guidance on &#8230;</li>
<li>Dubai Investment</li>
<li>&#8230;</li>
<li>&#201;cole de hautes &#8230;</li>
<li>&#8230;</li>
<li>L&#8217;Institut des Cadres Fiscaliste: &#8230;</li>
<li>&#8230;</li>
<li>Lutte contre les planifications fiscale</li>
<li>Majoration fiscale &#8230;</li>
<li>&#8230;</li>
<li>World Tour &#8230;</li>
<li>&#8230;</li>
</ol>
</div>
]]></description>
        	        	<pubDate>Mon, 11 Apr 2011 21:43:02 +0300</pubDate>
        </item>
</channel>
</rss>