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

date posted 11th October 2006 15:00

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)

;o)