[mythtv-users] Truncated programid - FIXED
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.
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 ...
character-set-server = latin1
default-character-set = latin1
(these were previously set at utf8)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users