<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.10.2">
</HEAD>
<BODY>
On Mon, 2007-01-01 at 11:50 -0500, James Orr wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
<FONT COLOR="#000000">Everything is working OK, except for one thing ... my programid is getting truncated to 6 characters.</FONT><BR>
</BLOCKQUOTE>
<BR>
Fixed it!<BR>
<BR>
I noticed this in my mysql log for every table ...<BR>
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<BR>
<BR>
When I checked the table in mythconverg it showed program as varchar(6)!<BR>
<BR>
I fixed it by setting in my.cnf ...<BR>
[mysqld]<BR>
character-set-server = latin1<BR>
default-character-set = latin1<BR>
<BR>
(these were previously set at utf8)<BR>
<BR>
</BODY>
</HTML>