Re: FN-FORUM: Storing the leading 0 of product codes in MySQL

date posted 11th October 2006 15:27

Quoting Tony Crockford [EMAIL REMOVED]

>
> Dave Cross wrote:
>> Quoting Paul Cooper [EMAIL REMOVED]
>>
>>> Text uses less memory than numbers.
>>
>> Do you have any evidence for that? It seems unlikely.
>
> see what you can make of this:
>
> http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
>
> looks to me like prior to MySQl5.0.3 a decimal type field was
> represented as a string and in fact needed an extra byte over the
> equivalent length string.
>
> If I've read it right.
>
> (not that it really matters)

Ah. Ok. but it looks like integers and floats work as expected. It's
just decimals that are broken :)

Yet another reason for not using MySQL before version 5!

Dave...

--
Magnum Solutions Ltd
Open Source Consultancy, Development and Training
http://mag-sol.com/