[mythtv-users] Database update schema error with trunk utf8

[Mike Perkins]

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