Re: Re: Upload File

thank you Edward. Edward Vermillion wrote:

On May 10, 2006, at 10:53 AM, Peter Hoskin wrote:

GOOGLE DO NOT ARGUE

o_O....?

yeah! I did figure it really was about time they changed their 'Do No Evil' slogan given their escapades in china funnily enough I watched a documentary the other day about the potential for information/propaganda abuse given the way major search engines operator and dominate. 'Google: do not argue' is pretty fitting all in all. lol.

So, if ASCII and Binary are both codesets... which does SQL use to store its data?

ASCII is a codeset, utf* is a codeset.... binary is a, um... , binary data. varchar, etc => ASCII/utf*/whatever => stored as text int, etc => integer => stored as integer or long or whatever BLOB => Binary Large OBject => stored as binary data

there is a funny little story about where the name BLOB came from: http://www.cvalde.net/misc/blob_true_history.htm

While you're right that it's better performance and maintenance wise to use the filesystem to store binary objects, especially very large ones, it's not necessarily 'wrong' to use MySQL. http://dev.mysql.com/doc/refman/5.1/en/index.html Ed