[mythtv] patch: progfind speedup

[Torbjörn Jansson]

I tried the progfinder in cvs from yesterday.
Why do i get program starting with the letters ä and ö under A ?
Maybe another utf8 bug/problem?


> -----Original Message-----
> From: mythtv-dev-bounces at snowman.net 
> [mailto:mythtv-dev-bounces at snowman.net] On Behalf Of Andy Davidoff
> Sent: Monday, March 03, 2003 4:32 AM
> To: mythtv-dev at snowman.net
> Subject: Re: [mythtv] patch: progfind speedup
> 
> 
> While you're looking at this code, would you consider breaking
> out the 'A ...' titles as you have the 'The ...' titles?
> 
> 
> #if John Danner /* Mar 02, 22:13 */
> > Thanks for the patch. The code as I originally had it 
> doesn't even use the 
> > channel information at that point. 
> > 
> > So i've updated CVS to use this:
> > 
> > "SELECT DISTINCT title FROM program WHERE title LIKE '%1%' 
> AND starttime > %2 
> > ORDER BY title;"
> #endif /* johndanner at untzuntz.com */