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?
I'm not 100% sure but I remember reading about a binary compare option in the documentation that I bet would do the trick. Take a look at that.
Chris W http://thewishzone.com:8086/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]