[mythtv-users] MythTV, phpMyAdmin and German umlauts

Brad DerManouelian myth at dermanouelian.com
Thu Jun 26 21:19:41 UTC 2008


On Jun 26, 2008, at 2:10 PM, Torsten Crass wrote:

> Hi there,
>
> German umlauts seem to be a recurring issue with MythTV... Actuall,
> everything works fine for me (DVB-T EPG data, display in frontend  
> etc.)
> -- until I try to edit some mythconverg.recorded entry containing 
> umlauts in the title/subtitle/description field using phpMyAdmin.
> Although the umlauts show fine in the MySQL command-line client, in
> phpMyAdmin they get displayed up as funny double-characters. Example
> (though I don't know whether this will survive e-mailing):
>
> "Die größte Waldlandschaft der Erde..."
>
> shows up as
>
> "Die größte Waldlandschaft der Erde..."
>
> I tried changing the affected column's and/or the connection's  
> collation
> to utf8 (which is the default locale on all my systems), but the only
> change was that little boxes were displayed instead of funny  
> characters...
>
> Someone once said something like "At the first glance, character
> encoding may look rather difficult. But in reality, it's even  
> worse". I
> tend to agree.
>
> So any ideas, anyone?
>
> Best Regards --
>
> 	tcrass

Make sure phpMyAdmin is using the same character set as your database.  
There is a global setting for this.
Secondly, don't edit those fields with phpMyAdmin. :)



More information about the mythtv-users mailing list