[mythtv-users] Truncated programid - FIXED

James Orr james at orrwhat.net
Mon Jan 1 18:20:01 UTC 2007


On Mon, 2007-01-01 at 11:50 -0500, James Orr wrote:

> Everything is working OK, except for one thing ... my programid is
> getting truncated to 6 characters.


Fixed it!

I noticed this in my mysql log for every table ...
070101 13:08:15 [Warning] './mythconverg/program' had no or invalid
character set, and default character set is multi-byte, so character
column sizes may have changed

When I checked the table in mythconverg it showed program as varchar(6)!

I fixed it by setting in my.cnf ...
[mysqld]
character-set-server            = latin1
default-character-set           = latin1

(these were previously set at utf8)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070101/ce8d0ffa/attachment.htm 


More information about the mythtv-users mailing list