Posted by Captain Paralytic on 07/03/07 12:27

On 3 Jul, 12:23, "mrcakey" <nos...@spamispoo.com> wrote:
> "Captain Paralytic" <paul_laut...@yahoo.com> wrote in message
>
> news:1183460553.581960.33590@g4g2000hsf.googlegroups.com...
>
>
>
>
>
> > On 3 Jul, 11:45, "mrcakey" <nos...@spamispoo.com> wrote:
> >> "Captain Paralytic" <paul_laut...@yahoo.com> wrote in message
>
> >>news:1183458148.394512.69990@q75g2000hsh.googlegroups.com...
>
> >> > On 3 Jul, 10:35, "mrcakey" <nos...@spamispoo.com> wrote:
> >> >> Utterly perplexed by this one. I entered this into my MySQL:
>
> >> >> create table if not exists user
> >> >> (userid int not null auto_increment primary key,
> >> >> email char(64) not null,
> >> >> nickname char(32),
> >> >> user_pass char(41),
> >> >> reset_ans char(41),
> >> >> block_timestamp timestamp,
> >> >> blocked tinyint,
> >> >> fail_cnt tinyint,
> >> >> auth_pending tinyint,
> >> >> default_home tinyint,
> >> >> pref_email_newsletter tinyint,
> >> >> pref_email_own tinyint,
> >> >> polled tinyint,
> >> >> nominations tinyint,
> >> >> songalike_count int );
>
> >> >> When it came out at the other end, phpMyAdmin is reporting that all
> >> >> the
> >> >> INTs
> >> >> are 11 bytes long and the TINYINTs are 4 bytes long. I've no idea
> >> >> what's
> >> >> going on here?!!!!
>
> >> >> Also, a related issue, is it necessary to align the fields in byte
> >> >> pairs?
> >> >> This comes from my Tandem programming background - data was stored in
> >> >> byte
> >> >> pairs, so if you had a field that was 5 bytes long for instance, you'd
> >> >> try
> >> >> to stick an odd-byte field next to it so that space wasn't wasted. Do
> >> >> I
> >> >> need to do this for MySQL (just using ISAM)?
>
> >> >> +mrcakey
>
> >> > To find out what's going on here, I can recommend reading the manual:
>
> >> >http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
>
> >> Thank you. I had spent a good 20 minutes looking at the manual, but
> >> apparently not at the relevant bit. Seems a very weird thing for
> >> phpMyAdmin
> >> to want to add the display length when it's not needed.
>
> >> +mrcakey- Hide quoted text -
>
> >> - Show quoted text -
>
> > The writers of phpMyAdmin obviously didn't realise that you didn't
> > need that information. In their ignorance they went and built it to
> > display all the relevant information about the fields, for all the
> > other people who need to know the details. Crazy huh!
>
> > I notice the same with MicroSoft Windows. There are things in here
> > that I find totally unnecessary. So I assume that no one else needs
> > those features either!
>
> Wow. How dumb do I feel? You really got my number. Facetious gimp
>
> +mrcakey- Hide quoted text -
>
> - Show quoted text -

But at least I answered your original question ;-)

[Back to original message]