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]
