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

[Stuart Morgan]

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 ;)
-- 
Stuart Morgan