One relative question: If with "binary" flag OFF the database makes upercase conversion to the field then where does it keep it? It dublicates it for search purposes? Because it is kept with origin form too, of course. Or it makes it on the fly? To slow I suppose and another friend on this list told me I can use BINARY clause with WHERE but it is slow in contrary with "binary" flag on the field description.
Makis > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 23, 2002 11:04 PM > To: savaidis; [EMAIL PROTECTED] > Subject: RE: Comments in Documentation > > > At 19:54 +0200 2/23/02, savaidis wrote: > >I say "by default" means to do nothing, not to do the > upercase conversion as > >I suppose it does to the fields. > > As it happens, the standard SQL behavior for LIKE is to not be case > sensitive. Which is roughly equivalent to doing an uppercase > conversion. > You appear to be saying that it's a bad thing for MySQL to > use the standard > behavior. > > >I haven't met since now the "binary" as an alternative to > "case sensitive" > >and I'm quite old in programming and age believe me :) > >Also if I knew SQL already, then I didn't have to read the > MySQL manual. > >If you don't know there is a LIKE function then how to go > and look for it? > > Your original question appeared to imply that you already > knew about LIKE, > and that you were wondering where it was in the manual. Not > that you were > wondering whether there was any such thing in SQL itself. > > > > >Makis > > > > > >> -----Original Message----- > >> From: Paul DuBois [mailto:[EMAIL PROTECTED]] > >> Sent: Saturday, February 23, 2002 10:21 PM > >> To: savaidis; [EMAIL PROTECTED] > >> Subject: RE: Comments in Documentation > >> > >> > >> At 19:28 +0200 2/23/02, savaidis wrote: > >> >Instead of "binary" it sould be better to use a "case > >> conversion" flag with > >> >reverse function - NOT set by default. > >> > >> You have to have *something* on by default. I guess I don't > >> understand > >> what you're getting at. I'd say BINARY is reasonably > >> concise. Perhaps > >> you have an alternative, but you haven't actually specified > >> any syntax, > >> so it's difficult to say whether or not it might be better. > >> > >> > "Binary" doesn't make sence to me. > >> > >> BINARY is nothing more than a synonym for "case sensitive". > >> > >> >As for LIKE I think most WHERE commands use it so it is > >> obvious it should be > >> >there. > >> > >> I disagree. It is not obvious in the slightest that the > >> section on WHERE > >> should be turned into a list of possible functions that can > >> be used there. > >> Most such functions can also be used in the output column > >> list, ORDER BY, > >> GROUP BY, etc. Functions should be documented in the section > >> on functions. > >> As, in fact, they are. > >> > >> > > >> > > >> >Makis > >> > > >> > > >> >> -----Original Message----- > >> >> From: Paul DuBois [mailto:[EMAIL PROTECTED]] > >> >> Sent: Saturday, February 23, 2002 6:29 PM > >> >> To: savaidis; [EMAIL PROTECTED] > >> >> Subject: RE: Comments in Documentation > >> >> > >> >> > >> >> At 16:01 +0200 2/23/02, savaidis wrote: > >> >> >Also there is not LIKE at all at SELECT command on > MySQL manual! > >> >> > >> >> http://www.mysql.com/doc/S/t/String_comparison_functions.html > >> >> http://www.mysql.com/doc/P/a/Pattern_matching.html > >> >> > >> >> >I found manual very-very amateur work. > >> >> >I was trying about half hour to use <WHERE FIELD1= > "mpla-mpla%"> > >> >> > >> >> I'm surprised that if you wanted to use LIKE, that > you didn't just > >> >> try it. > >> >> > >> >> >Also "binary" at field creation or WHERE should be > ON by default. > >> >> > >> >> What would the syntax be for turning it off? > >> >> > >> >> > And WHERE > >> >> >works erroneously with Greek chars (without the "binary" > >> >> option). I think it > >> >> >is comfused by other languages chars so it should be an > >> >> option to declare > >> >> >the language character set at runtime (not at server cnf). > >> >> > > > > > > >Makis > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
