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

Bruce Markey bjm at lvcm.com
Wed Feb 8 22:07:20 UTC 2006

MythTV wrote:
> #1246: MythTV UTF-8 for 'Custom Record' query
> ---------------------------------------+------------------------------------
>  Reporter:  Cougar <cougar at random.ee>  |       Owner:  ijr

Stop it! You, more than anyone else are trying to use Trac as
your own personal message board and/or surrogate help desk.

All(!) the tickets you've opened are invalid (see the info at http://cvs.mythtv.org/trac/wiki/TicketHowTo ) and are veiled
attempts to get support service for your misunderstanding.

Post to the mailing lists from now on. I will close any ticket
you open as invalid from now on unless someone else can verify a
reproducible test case and submit a proper ticket.

>      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.

English may not be your first language but get help with the
translation if necessary:

  Database error was:
  Column 'title' in where clause is ambiguous

This means more than one table has a 'title' column and it should
have been 'program.title' just like every one of the examples.

--  bjm

More information about the mythtv-dev mailing list