[mythtv-users] MythV's mysql d/b - should it be UTF-8?

[Neil Bird]

   Currently, the default seems to [still] be latin1 as the encoding, not 
utf-8.  This does make manual/scripted access a tad tricky when there are 
non-ASCII characters present.

   Now, my understanding of it is that it shouldn't actually make any 
difference to Myth how the table is configured in that respect, as the text 
will still be UTF-8 encoded, but I may be wrong.  So:

a) *Does* it make a difference?

b) If not, how can I safely convert my tables from latin1 to UTF-8?  I tried 
a couple of simple recipes that Mr. Google pointed me to, but nothing was 
quite right.

c) Is the latin1 default correct?  I'm going by the mysql.txt (?) that comes 
with MythT & contains the d/b creation commands.

-- 
[neil at fnx ~]# rm -f .signature
[neil at fnx ~]# ls -l .signature
ls: .signature: No such file or directory
[neil at fnx ~]# exit