I am using 4.0.18. I also checked out the "Bugs Fixed" report--and it kind of looks like #2295 applies, although I can't be certain. It definitely returns rows without trailing spaces, even though the SELECT asks for rows WITH trailing spaces.
Hmmm... on 5/2/04 2:05 AM, Matt W at [EMAIL PROTECTED] wrote: > Hi John, > > What version do you use? In 4.0.18, they fixed some bugs that were > introduced in 4.0.17 related to trailing spaces on indexed TEXT-family > columns: http://dev.mysql.com/doc/mysql/en/News-4.0.18.html > > I see 3 "Bugs fixed" entries with "trailing spaces" in them. If you're > not using 4.0.17, what you're seeing IS a bug and should be reported if > it hasn't already been. > > > Matt > > > ----- Original Message ----- > From: "John Mistler" > Sent: Friday, April 30, 2004 1:39 PM > Subject: Another Trailing Spaces Issue > > >> The TINYTEXT format solves the problem of storing the string with > spaces at >> the end. Now, I'm having trouble SELECTING a row WHERE the > TINYTEXTcolumn = >> theStringWithTheSpacesAtTheEnd; >> >> If the string is theString + space and another row has an entry with >> theString (+ no space), the query returns BOTH rows. >> >> Is there a way to get around returning the latter entry? >> >> Thanks, >> >> John > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
