[mythtv] Qt4 port: database character set change necessary

Denys Dmytriyenko denis at denix.org
Mon Mar 24 18:51:05 UTC 2008


On Mon, Mar 24, 2008 at 06:30:12PM +0000, Stuart Morgan wrote:
> On Monday 24 March 2008 17:52:00 Denys Dmytriyenko wrote:
> > > After my last move to a different backend machine I completely dropped
> > > the database and created a new one with utf-8 as it's character set.
> >
> > Same here. I had to convert my MythMusic and MythVideo tables to UTF8 long
> > time ago, as to be able to see non-latin characters. And I know many more
> > people have done the same. So I'd vote for native UTF8 support in Myth,
> > regardless of 3 times bigger char() and varchar() in MySQL.
> 
> We've always used UTF8, just stored in latin1 fields for space reasons. All 
> reported utf8 problems were fixed, so I can only guess you never bothered to 
> report them. *sigh*

Actually, when I was configuring MythMusic for UTF8 several years ago, I did 
report few issues. And then late last year when I was working on my MythVideo 
movie metadata lookup script, I fixed another UTF8 related issue in the 
VideoManager code, but unfortunately, by that time the whole VideoManager was 
rewritten and I did not submit the patch... :)

Anyway, thank you all involved in bringing UTF8 into MythTV!

-- 
Denys


More information about the mythtv-dev mailing list