[mythtv-users] Unicode characters showing up as question marks

Yeechang Lee ylee at pobox.com
Tue Jan 16 16:57:43 UTC 2007


Dave M G <martin at autotelic.com> says:
> Whoever designed the MySQL database left the collation settings at the 
> default - which is (for some reason) "latin_swedish_ci".
> 
> I changed all the text fields on the "program" table to use 
> "utf8_unicode_ci" as their collation. Then I set the collation for the 
> table and the collation for the whole database to be "utf8_unicode_ci" 
> as well.

What I forgot to ask in my previous reply is, how does one do the
above? I know nothing about SQL syntax beyond what was required to set
up MythTV.

-- 
Yeechang Lee <ylee at pobox.com> | +1 650 776 7763 | San Francisco CA US


More information about the mythtv-users mailing list