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 PROTECT
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,
>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?
You could do something like:
select stuff from mytable where stuff = 'foo ' and length(stuff) = 4;
--
Steve Ba
John Mistler wrote:
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),
