[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