[mythtv] [mythtv-commits] Ticket #2461: Mythfilldatabase fix removing existing and inserting same program and date format

[Paul Andreassen]

On Sun, 7 Jan 2007 08:53 pm, Stuart Morgan wrote:
> On Sunday 7 January 2007 04:39, MythTV wrote:
> > #2461: Mythfilldatabase fix removing existing and inserting same program
> > and date format
> >
> >  I don't know much about utf8.  Why doesn't the (*todelete).channel and
> >  (*tokeep).channel need a .local8Bit()?
>
> Well I'll take an educated guess at that but I'll confess character sets
> (and related conversions) are not my strong point either.
>
> Channel is the xmltvid, which according to the DTD should conform to
> RFC2838 (Uniform Resource Identifiers for Television Broadcasts) which
> itself inherits from RFC2396 (Uniform Resource Identifiers). In other words
> it's a traditional domain name and follows the rules governing them,
> meaning that it uses a limited set of characters. N.B. RFC2838 doesn't
> allow for the newer IDN as far as I can tell.
>
> Converting to UTF8 wouldn't change anything as it uses the same codes for
> those characters, but it's not necessary either.
>
> As I understand it*, mythtv aims to store everything in UTF8. This means
> converting incoming data to UTF8 before saving to the database but also
> coverting back when fetching it later. I can't commit the UTF8 changes
> until I've checked that there is a corresponding fromUTF8 on those fields
> whereever they are used.
>
> * Someone will now come along and make my look very stupid ;)

Ok, thanks for the replying.

Paul
--