No subject


Sat Apr 15 04:39:11 UTC 2006


same size for mysql 3.x,4.x,5.x)

smallint is 2 bytes, so unsigned that gets up to 65535

int is 4 bytes, and tinyint is 1 byte

henri

------=_Part_16886_4262947.1145816026427
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br><br><div><span class=3D"gmail_quote">On 4/23/06, <b class=3D"gmail_send=
ername">Daniel Kristjansson</b> &lt;<a href=3D"mailto:danielk at cuymedia.net"=
>danielk at cuymedia.net</a>&gt; wrote:</span><blockquote class=3D"gmail_quote=
" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0=
.8ex; padding-left: 1ex;">
On Sun, 2006-04-23 at 10:27 -0700, henri naccache wrote:<br>&gt; is there a=
 reason why recordedmarkup should have &quot;int&quot; as the type for<br>&=
gt; chanid and type?<br>&gt;<br>&gt; it seems that for type tinyint would w=
ork, and for chanid smallint
<br><br>I don't know how big smallint is but 5 decimal digits should be<br>=
sufficient for chanid. We might need to get rid of autoincrementing<br>of t=
he sourceid, but that should only be a few bits of code.</blockquote><div>
<br>


More information about the mythtv-dev mailing list