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 on 4/30/04 2:42 AM, Matt W at [EMAIL PROTECTED] wrote: > Hi John, > > I *think* VARCHAR is *supposed* to work that way, but doesn't in MySQL. > So you'll have to use TINYTEXT. Its storage requirements are the same > as VARCHAR(255) and it behaves the same way, except for, I think, 3 > things: 1) the trailing space thing, obviously; 2) it can't have a > DEFAULT value; and 3) you can't index the whole column -- but you can > INDEX (col(255)), which has the same effect. :-) > > Hope that helps. > > > Matt > > > ----- Original Message ----- > From: "John Mistler" > Sent: Friday, April 30, 2004 3:54 AM > Subject: Storing a space > > >> Is there a way to force an invisible "space" character to be stored at > the >> END of a string in a column (either VARCHAR or CHAR), so that when it > is >> retrieved the space at the end is not cut off? >> >> theString + space >> >> or even, >> >> theString + space + space + space, etc. >> >> Currently, I can only get the string back as theString >> >> Thanks, >> >> John > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
