name - use varchar as text fields cannot be indexed at least not in MySQL As far blob vs text they're pretty much synonyms for same type. Only difference is that blob is case sensitive on sorts and criteria where text is insensitive.
On 02/06/05, Tom MacKean <[EMAIL PROTECTED]> wrote: > > > > Just wondering… > > > > What's better for a name – tinytext or varchar(20) – or doesn't it matter. > > > > And what's the difference between a blob field and a text field? > > > > Tom --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] Aussie Macromedia > Developers: http://lists.daemon.com.au/ > > NOTICE: Medical and scientific information provided in print and > electronically by Sydney IVF might not be relevant to your own circumstances > and should always be discussed with your own doctor before you act on it. > This communication is confidential and may contain copyright or otherwise > protected information of Sydney IVF Limited or a third party. If you are not > the intended recipient of this communication please immediately let us know > by reply email or telephone us on +61 2 9221 5964, delete the communication > and destroy all copies. b‹šç.®·§¶\¬¹» ®&ÞvÚ }«¬²'š±ªÜ†+Þ™¨¥j·!Š÷œ¢dèº{.nÇ+‰·¬zwZnV§‘隊[h•æ¯yÇÚºË"{~ºàIb²Û ié¨?Ê&jà.²Èž1§+¢g?‰ Þ½éh¥êì†Ûiÿùb²Û ié¨?Ê&jï
