> "If you can't search using the data, it doesn't belong in a database." - > This is a stupid statement: there are fields in a database used for search > and fields to hold data. Let's consider for example a phone book in the way > it was designed as a book: you may search using the name and find the > address and phone number. While a database implementation can search also > using the phone number, the address may create problems: punctuation, extra > blanks etc. This does not mean that the address place is not in the > database!
You are missing the point. You cannot use any kind of blob data in a query clause, period. In your address example, you can still use LIKE to search within the address, and the address itself is text, so you could, for example, sort by the address. Putting the data in the database cannot add any functionality and could very well cause a number of other problems with hitting the maximum size limit of the database or backing up the database, etc. If YOU want to put blob data in your database, go ahead, but think before call someones analysis a stupid statement. Just because you have not encountered these issues yet does not mean they do not exist. Glenn Lawler ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
