[mythtv] mythtv commit: r23016 - in trunk by stuartm

[David Engel]

On Thu, Dec 31, 2009 at 10:40:13PM -0500, Michael T. Dean wrote:
> FWIW, a large number of people have corrupt names in their people
> table because they corrupted their database back when we used latin1
> storage and they followed the old instructions on the HOWTO for
> doing a "new hardware/partial restore".  The procedure given always
> corrupts.

I don't recall running any such instructions.  I restored oldrecorded
some time ago by using mysqldump --> edit --> mysql, but I don't
believe I did so for the entire database.  It's been long enough, that
I'm not entirely sure though.  Is there any way to tell after the
fact?

> Out of curiosity, what do you get from:
> 
> SELECT person, name, HEX(name) FROM people WHERE name LIKE 'Kerry B%';

Here is what I get:

mysql> SELECT person, name, HEX(name) FROM people WHERE name LIKE 'Kerry B%';
+--------+--------------+--------------------------+
| person | name         | HEX(name)                |
+--------+--------------+--------------------------+
|  50757 | Kerry Barden | 4B657272792042617264656E | 
|  22382 | Kerry Beyer  | 4B65727279204265796572   | 
|  88818 | Kerry Bishe  | 4B65727279204269736865   | 
|  99652 | Kerry Bishé  | 4B657272792042697368C3A9 | 
|  16082 | Kerry Butler | 4B65727279204275746C6572 | 
+--------+--------------+--------------------------+
5 rows in set (0.00 sec)

I'm not sure how it displays on your end, but the second instance of
"Kerry Bish?" is correct in konsole on my end with the accent over the
'e'.  When I view it in the program details screens using MythCenter
and Terra, the accent-'e' is replaced with tilde-'A' and the copyright
symbol.

David
-- 
David Engel
david at istwok.net