[mythtv-users] Database update schema error with trunk utf8
Mike Perkins
mikep at randomtraveller.org.uk
Wed Dec 17 11:17:34 UTC 2008
freedenizen wrote:
> It must be standard in gentoo not to include latin1 support for mysql,
> as I have never specified -latin1, that is just default. I've never
> had any other database problems in the years of using myth. This is
> my 3rd myth server, so I can't be sure that the other ones didn't have
> latin1, but they have all been gentoo boxes, so my guess is they were
> configured the same.
>
> Actually maybe I do have some weird latin1 support built in, but swedish?!
> mysql> SHOW CHARSET LIKE 'latin1%';
> +---------+----------------------+-------------------+--------+
> | Charset | Description | Default collation | Maxlen |
> +---------+----------------------+-------------------+--------+
> | latin1 | cp1252 West European | latin1_swedish_ci | 1 |
> +---------+----------------------+-------------------+--------+
> 1 row in set (0.00 sec)
>
> very odd...
>
Not so odd. I believe the original developers of MySQL were Swedish.
--
Mike Perkins
More information about the mythtv-users
mailing list