Re: Size of BLOB types?

2005-04-16 Thread Robert Dunlop
or 65K of disk space for each element. Just because you have no use for it doesn't mean others don't. My experience with most DB software is that it's driven by requirements, not whim. ----- Original Message - From: "Dan Bolser" <[EMAIL PROTECTED]> To: &q

Re: Size of BLOB types?

2005-04-16 Thread Robert Dunlop
Your question was would a TINYBLOB hold 1,000 characters. TINYBLOB (TINYTEXT) = 257 characters. 1,000 > 257 = No. Your next option, BLOB (TEXT) = 64K. 1,000 < 64K = Yes. - Original Message - From: "Dan Bolser" <[EMAIL PROTECTED]> To: "Hassan Schroeder" <[EMAIL PROTECTED]> Cc: Sent: Sat

Re: zip code search within x miles

2005-04-15 Thread Robert Dunlop
I haven't looked into this recently, but as long as 15 years ago there were zip -> mile libraries available; I assume similar libraries still exist. The ones I worked with all used only the first 3 digits. Full five digit and nine digit zips get to pretty specific geographic locations, a level of

Re: mysqlconnecernet not closing connections w/2003

2005-03-30 Thread Robert Dunlop
not closing connections w/2003 > Robert- > > I apologize for not being clearer. > The operating system is Windows 2003 Server. > > Dan > > -Original Message- > From: Robert Dunlop [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 30, 2005 3:09 PM &g

Re: mysqlconnecernet not closing connections w/2003

2005-03-30 Thread Robert Dunlop
Dan, What is a "2003 server?" Do you mean Win2K? I'm not aware of any OS that references 2003. Perhaps that is part of the reason for no response? I don't have any MySQL systems running on Windows machines, so I can't answer your question, but perhaps there are those out there who can

Re: LOAD DATA INFILE using 4.0.17

2005-02-15 Thread Robert Dunlop
So what you meant was every field in each row must be unique from all other instances in all other rows? Not just each row must be unique? Bob - Original Message - From: "shaun thornburgh" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 15, 2005 2:40 PM Subject: Re: LOAD DATA INFILE usi