[mythtv] [mythtv-commits] Ticket #1246: MythTV UTF-8 for 'Custom Record' query

Kevin Kuphal kuphal at dls.net
Wed Feb 8 22:04:45 UTC 2006


MythTV wrote:
> #1246: MythTV UTF-8 for 'Custom Record' query
> ---------------------------------------+------------------------------------
>  Reporter:  Cougar <cougar at random.ee>  |       Owner:  ijr
>      Type:  defect                     |      Status:  new
>  Priority:  minor                      |   Milestone:     
> Component:  mythtv                     |     Version:     
>  Severity:  medium                     |  
> ---------------------------------------+------------------------------------
>  mythfrontend [8904] (almost latest). Found that when I have show where
>  title has international characters in UTF-8 like '''Pealtnägija.''' then
>  when I enter query '''title = 'Pealtnägija.' ''' I don't get any result.
>  I think this is not a case for title but any MySQL query in mythtv.
>
>  Here is result from mysql command line:
>
>  {{{
>  mysql> SELECT starttime,title FROM `program` where title = 'Pealtnägija.'
>  and chanid = 1001;
>  +---------------------+---------------+
>  | starttime           | title         |
>  +---------------------+---------------+
>  | 2006-02-11 11:00:00 | Pealtnägija. |
>  | 2006-02-08 20:05:00 | Pealtnägija. |
>  +---------------------+---------------+
>  }}}
>
>  Here is what mythfrontend does (-v database):
>
>  {{{
>  sending IMStart with 0 chars to 0x8271d88
>  sending IMEnd with 1 chars to 0x8271d88, text=ä
>  receiving IMEnd with 1 chars
>  2006-02-08 23:07:32.470 MSqlQuery: SELECT NULL FROM program,channel  WHERE
>  title = 'Pealtn�ija.'
>  2006-02-08 23:07:32.789 MSqlQuery: SELECT DISTINCT program.chanid,
>  program.starttime, program.endtime,     program.title, program.subtitle,
>  program.description,     program.category, channel.channum,
>  channel.callsign,     channel.name, program.previouslyshown,
>  channel.commfree,     channel.outputfilters, program.seriesid,
>  program.programid,     program.airdate, program.stars,
>  program.originalairdate,     program.category_type, oldrecstatus.recordid,
>  oldrecstatus.rectype, oldrecstatus.recstatus,     oldrecstatus.findid FROM
>  program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN
>  oldrecorded AS oldrecstatus ON     program.title = oldrecstatus.title AND
>  channel.callsign = oldrecstatus.station AND     program.starttime =
>  oldrecstatus.starttime WHERE channel.visible = 1   AND program.endtime >
>  '2006-02-08T23:07:50'   AND ( title = 'Pealtnägija.' )  GROUP BY
>  program.starttime, channel.channum,   channel.callsign, program.title
>  ORDER BY program.starttime, channum + 0  LIMIT 1000
>  2006-02-08 23:07:32.791 DB Error (ProgramList::FromProgram):
>  Query was:
>  SELECT DISTINCT program.chanid, program.starttime, program.endtime,
>  program.title, program.subtitle, program.description,
>  program.category, channel.channum, channel.callsign,     channel.name,
>  program.previouslyshown, channel.commfree,     channel.outputfilters,
>  program.seriesid, program.programid,     program.airdate, program.stars,
>  program.originalairdate,     program.category_type, oldrecstatus.recordid,
>  oldrecstatus.rectype, oldrecstatus.recstatus,     oldrecstatus.findid FROM
>  program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN
>  oldrecorded AS oldrecstatus ON     program.title = oldrecstatus.title AND
>  channel.callsign = oldrecstatus.station AND     program.starttime =
>  oldrecstatus.starttime WHERE channel.visible = 1   AND program.endtime >
>  '2006-02-08T23:07:50'   AND ( title = 'Pealtnägija.' )  GROUP BY
>  program.starttime, channel.channum,   channel.callsign, program.title
>  ORDER BY program.starttime, channum + 0  LIMIT 1000
>  Driver error was [2/1052]:
>  QMYSQL3: Unable to execute query
>  Database error was:
>  Column 'title' in where clause is ambiguous
>  }}}
>
>   
The error isn't UTF-8, but ambiguous title.  Use program.title instead 
of title and try again.

Kevin


More information about the mythtv-dev mailing list