[mythtv-users] MythV's mysql d/b - should it be UTF-8?
Neil Bird
neil at fnxweb.com
Tue May 8 09:13:27 UTC 2007
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
More information about the mythtv-users
mailing list